Options

HOw could i access the MS-Access Database?

madhuri.sysmadhuri.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

  • Options
    AdministratorAdministrator Member, Moderator, Administrator Posts: 2,496
    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.
  • Options
    SaalekSaalek 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
  • Options
    aciaci 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.
  • Options
    madhuri.sysmadhuri.sys Member Posts: 13
    thanks my friends..

    Regards..
Sign In or Register to comment.