Requirement to transfer info from Access DB to NAV 5.0

Jay2007
Jay2007 Member Posts: 50
edited 2008-08-20 in NAV/Navision Classic Client
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

Comments

  • Waldo
    Waldo Member Posts: 3,412
    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 ... .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Eugene
    Eugene Member Posts: 309
    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

Categories