Software

Ask something
Discussion Locked

Excel-Access

0 helpful
5 replies

by ravenhawk 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I installed an Excel spreadsheet on a user's desktop, which contains a Macro.
When selected, the Macro is suppose to retrieve data from Access using Microsoft queries. Instead, it appears it is looking for the ODBC driver. When I tried to refresh the data without using the macro I received an ODBC error.

5 replies

by sgt_shultz

look at control panel odbc. driver may already be installed. if not, you can download from www.microsoft.com downloads section. easy to install driver. pretty easy to configure odbc. just read screen carefully and pretty much take defaults.

by d_gilmour_1978

You need to ensure that the ODBC connection name is the same on the users computer as the macro.
Also ensure that the ODBC connection has the correct path to the access database. Also note that MS Query requires a database connection which could be an ODBC connection.

This discussion is closed to new replies.