Requirement to transfer info from Access DB to NAV 5.0

Jay2007

Hi All,


I need to design a form in NAV to retrieve data in an Access 2007 DB and store in NAV 5.0.

Can anyone give me simple instructions on how to do this? I have managed to code it to open database but cannot figure out the commands to access particular fields in a table in the Access DB.

I have looked at the post Using "ADO & Stored Procedures in C/SIDE" and my reading of this is that a query needs to be added to Access DB to return the info. Is this correct or am I misreading it??

Thanks,

Jay

Waldo

I think you're misreading it ... .
You can use an AccessDB (will differ in the connectionstring) and just fire SQL statements in the commandtext (not using SP's at all - so it's a different command type as well...).

There are numerous posts about this on this forum ... .

Eugene

i'd suggest you to use ADO library and start with ADOConnection automation object.

BTW if it is one time operation importing data from Access then it maybe cheaper/faster to export the data as plain text files and import it via dataports