You can use the "get external data" feature in Access to import an excel
spreadsheet. You can even link right to the spreadsheet and use that data
in the database.
I've got an article coming out soon at dbj, but in the mean time, you can test
out the code. It's simple, but will work for you if you need automation.
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.
