Linked tables

[pauldooley]

Hi all,

Is it possible to pull a number of linked tables into one database? I have 80 excel files which I pull data from, I use a macro for this currently but the linked tables would bexpect prefect.

Also, each month I roll forward these files, can I edit the links to the tables in access?

Many thanks

 

[Joe4]

I think the easiest thing to do is set up your linked tables (I don't believe there is a limit).
Then, instead of changing the links each month, just overwrite the old files with the new files. If you use the exact same file names, you won't need to change anything.