HOw could i access the MS-Access Database?

madhuri.sys
madhuri.sys Member Posts: 13
HI all ,
i am trying to access the data in MS-Access database, and put into the Navision database using automation variable of 'Microsoft Access 9.0 Object Library'.Application.

i am able to open the database, but not getting the data from a single table.

so suggest me how can i do this?

thanks in advance...

Comments

  • Administrator
    Administrator Member, Moderator, Administrator Posts: 2,507
    Topic moved from "Navision Tips & Tricks"-forum to Navision-forum.

    The Tips & Tricks forum is not the place to ask questions, as explained in the forum description.
  • Saalek
    Saalek Member Posts: 181
    Hi
    Is better if you use ADO to retrieve data from access.

    Th automation is Microsoft Activex Data access Object library 2.7 (in service pack 5)

    Bye
  • aci
    aci Member Posts: 41
    Use the latest ADO version listed on your computer, this will automatically use the latest version on the client, be that version 2.5, 2.6, 2.7, or 2.8.

    If you select in older version, then you are forcing the version number, and your code will not run on clients that don't have this specific version number.
  • madhuri.sys
    madhuri.sys Member Posts: 13
    thanks my friends..

    Regards..