Multiple link, Access????

[John Ellis]

If someone can Help!
I am trying to link many Excel spread sheets to each other
using Access. I can do one, but no more. Thanks for any help you can me.
JP

 

[Fons Ponsioen]

Without more detail, I would suggest opening an mdb and
linking each of the excel datasheets using file > get
external data > link.
This will list each of the data sheets as a table.
Now you can use queri(es) to make the desired relations.
I have experienced some issues with data types etc.
Give it a try,
Hope this helps.
Fons