Your Access query must return a single value
Menu : Data > Get External Data > New Database Query..
In the Dialogbox click on the Database page (default) and select "MS Access Database" and click "OK"
In the next dialog box select the location of your database (.mdb). The another dialogbox is opened containing the list of available tables and queries of your database. Then select your query and follow the steps of the wizard
When finished, you have in the Data menu a new option to "Refresh Data".
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
