Hi,
I have generated ODC file (which contains real time data from Dynamics AX) and I would like to add this file to data model.
I can get data from .odc file as a table in Excel and if I update connection everything is working, however when I am trying to add this to data model, every time...
I have a server to which I access my data. Let's call it 190.250.65.210.
To get data from this in Access I do this:
1. Click on the "ODBC Database"-import Tab in Access
2. Then choose"SQL Sever" (from the listbox-menu) as Driver
3. And type in the Server: 190.250.65.210
4. I then press next...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.