How to link single excel spreadsheet to multiple access tables



Is it possible to link a single spreadsheet to multiple tables. I have a
excel spreadsheet that contains with 22 columns of information. I would like
to link the spreadsheet to multiple (different tables), so that it will
update the tables everytime I update the spreadsheet.

If this is possible, instruction on how to will be greatly appreciated

Jeff Boyce

Not sure what you mean by "link spreadsheet to table"...

In Access, you can link to a spreadsheet ... and Access treats that link as
if it were a table.

Why would you want/need to link to the same spreadsheet multiple times?
What problem are you trying to solve with this approach?

More info, please...


Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer

Ask a Question

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.

Ask a Question