How to link single excel spreadsheet to multiple access tables

[tmdrake]

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...

Regards

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
possible/necessary.