If you want macro code then turn on Record Macro when doing the steps below.
Otherwise just do the steps below
1) Worksheet menu - Data - Import External Data - New Database Query
2) Select MS Asscess Database - OK
3) Select directory nad Databae Name - OK
4) then follow wizard instructions.
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.