Options

ODBC error in excel (from Navision)

ui2607ui2607 Member Posts: 2
Hello

I have runtime update my Navision from Navision 3.7 to Navision 5.0. That’s running very succesfully. I have install the ODBC drivers, and I can receive data in Excel from Navision 5.0 with out any problems. It works fine too:) The problem is that the old excel sheet that was created based on Navision 3.7 does not work any more. It comes with error message that:
[Microsoft][ODBC Driver Manager] Data source not found and no default driver specified.

Do anyone know how to change the datasource in excel so I can "link" it to the correct Navision database.

Best regards

Usman

Comments

  • Options
    SD-JRSD-JR Member Posts: 94
    Not sure which version of excel you are using but in 2007
    go to the data tab
    get external data, from other sources, from microsoft query.

    hope this helps

    jer.
    Regards,

    Ger
    Simply Dynamics Ltd
    skype: gf.simplydynamics
    Web: www.simplydynamics.ie
Sign In or Register to comment.