Multiple link, Access????

  • Thread starter Thread starter John Ellis
  • Start date Start date
J

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
 
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
 
Back
Top