Hello,
my problem is that I want to connect a table in Access database with a table in Navision database. I need to know if it is possible, what utility I need to do it and so on. Can anyone help me?
When you use C/ODBC, you can create a "Linked table" in Access. This "Linked table" is just a reference to the table in Navision. When you open the table in Access, it gets the data, through ODBC, from the Navision database.
Is this what you want?
No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
I`ll give a better definition of my problem. I need a table inside Access, which shows actual data from Attain table No. 27 - Item and I need this table to be related with another table inside Access. In present time I do it by exporting data to Excel Sheet. Then I import it to Access, but I have to do it once a day, and from time to time, some problems may occur.
When you use C/ODBC, you can create a "Linked table" in Access. This "Linked table" is just a reference to the table in Navision. When you open the table in Access, it gets the data, through ODBC, from the Navision database.
Is this what you want?
Hi,
that really could be what I`m looking for. Can you give me some more information about C/ODBC? How can I use it? What do I need to use it? And in the end, will I be able to make relation between this linked table and another table inside Access?
C/ODBC extends the Data Sources (ODBC) in the Control Panel in Windows.
I use Attain 3.01A. On the product CD, there is a CODBC folder. Run setup from here and follow instructions.
In the ODBC Control Panel, Add a new System DSN (this works better than File DSN).
The driver you will be using is C/ODBC 32 Bit. Set it up to work from your database (I have a server connection). Make sure you logon with admin rights, so that you have access to all tables!
Then in Access, create a new Database.
File - Get External Data - Import (or link...depends on your choice, I would recommend Import, as it is safer!)
Change 'Files of type' at the bottom of the dialog box to 'ODBC Databases'.
Click on 'Machine Data Source', and select the connection you just created, and wait for your company selection to appear.
Just a note - I have found that you cannot switch companies until you shut down access and reopen the db you created initially.
Comments
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
You will have to use CFRONT to do this.
Thanks
Best regards
Suresh.
Is this what you want?
I would just convert Access file to .csv and then do dataport.
Denis Petrov.
Hi,
I`ll give a better definition of my problem. I need a table inside Access, which shows actual data from Attain table No. 27 - Item and I need this table to be related with another table inside Access. In present time I do it by exporting data to Excel Sheet. Then I import it to Access, but I have to do it once a day, and from time to time, some problems may occur.
Can you give me an advice? Thanks a lot.
Hi,
that really could be what I`m looking for. Can you give me some more information about C/ODBC? How can I use it? What do I need to use it? And in the end, will I be able to make relation between this linked table and another table inside Access?
Thanks a lot.
I do what you are looking for, using C/ODBC.
C/ODBC extends the Data Sources (ODBC) in the Control Panel in Windows.
I use Attain 3.01A. On the product CD, there is a CODBC folder. Run setup from here and follow instructions.
In the ODBC Control Panel, Add a new System DSN (this works better than File DSN).
The driver you will be using is C/ODBC 32 Bit. Set it up to work from your database (I have a server connection). Make sure you logon with admin rights, so that you have access to all tables!
Then in Access, create a new Database.
File - Get External Data - Import (or link...depends on your choice, I would recommend Import, as it is safer!)
Change 'Files of type' at the bottom of the dialog box to 'ODBC Databases'.
Click on 'Machine Data Source', and select the connection you just created, and wait for your company selection to appear.
Just a note - I have found that you cannot switch companies until you shut down access and reopen the db you created initially.
Hope this helps!
Stephen H.