So i was doing an assignment on calc at school and by mistake i saved my document in odc and sended it. Can you please tell me if odcs can still be opened with all the things i've done or not? Or just converted in other file type?
Hey, it doesn't work for me as I have a lot of data and only create connection and load to data model in my orgiginal file. Now, how to use that data model from original file in another files - in other words how to save ODC file of that data model? Thanks!
Isn't it STUPID of Microsoft to put a data mining tool in Excel AND LEAVE IT OUT OF THEIR, YOU KNOW, ACTUAL DATABASE PROGRAM called ACCESS? You can't even OPEN an ODC file in ACCESS to get DATA using their actual DATABASE PROGRAM. WTF GOOD IS ACCESS?
Access is a different program. It's a database, meant for storing data. Not really an Access guy but my understanding is you have the full power of SQL and can connect from other programs. So you aren't limited to Microsoft's UI for managing that data, you can use anything that would work with another SQL database. So you may want to explore that route. Alternatively, it does appear possible to use a web query with excel as a middleman, so that may be an option depending on your situation: smallbusiness.chron.com/use-query-files-access-42344.html Just as an observation, Access appears to be in less rapid development and given less attention. Excel is a far more popular program and Microsoft has been doing a ton to keep it a competitive tool. They've been adding lots of new features into the 365 version. The PowerQuery add-in itself only dates back to Office 2010, but really came into its own by about Office 2016. It's not fully available in the Mac version yet. So it's possible that similar features may be improved in Access at some point, but the program just isn't developing at the same rate as Excel.
Great tip. Thanks.
In Excel 2016 i cannot create .odc (export connection file is grey) but i can open .odc in very similar way to explained here.
Neat. Thanks!
So i was doing an assignment on calc at school and by mistake i saved my document in odc and sended it. Can you please tell me if odcs can still be opened with all the things i've done or not? Or just converted in other file type?
Hey, it doesn't work for me as I have a lot of data and only create connection and load to data model in my orgiginal file. Now, how to use that data model from original file in another files - in other words how to save ODC file of that data model? Thanks!
Isn't it STUPID of Microsoft to put a data mining tool in Excel AND LEAVE IT OUT OF THEIR, YOU KNOW, ACTUAL DATABASE PROGRAM called ACCESS? You can't even OPEN an ODC file in ACCESS to get DATA using their actual DATABASE PROGRAM.
WTF GOOD IS ACCESS?
Access is a different program. It's a database, meant for storing data. Not really an Access guy but my understanding is you have the full power of SQL and can connect from other programs. So you aren't limited to Microsoft's UI for managing that data, you can use anything that would work with another SQL database. So you may want to explore that route. Alternatively, it does appear possible to use a web query with excel as a middleman, so that may be an option depending on your situation: smallbusiness.chron.com/use-query-files-access-42344.html
Just as an observation, Access appears to be in less rapid development and given less attention. Excel is a far more popular program and Microsoft has been doing a ton to keep it a competitive tool. They've been adding lots of new features into the 365 version. The PowerQuery add-in itself only dates back to Office 2010, but really came into its own by about Office 2016. It's not fully available in the Mac version yet. So it's possible that similar features may be improved in Access at some point, but the program just isn't developing at the same rate as Excel.