Link multiple excel files at one time

[JE]

I have about 60 excel files that I want to link in an Access database. Other
than manually link each file individually, is it possible to link all at one
time?

Many thanks!

 

[John W. Vinson]

I have about 60 excel files that I want to link in an Access database. Other
than manually link each file individually, is it possible to link all at one
time?

Many thanks!

How can your program determine which excel files should be linked? All of the
..xls files in a folder, or what?

You can use VBA code with the TransferSpreadsheet method to create a link from
scratch - see the VBA help for the method.

 

[JE]

The database is not yet created. In a previous db which was similar, I
manually linked each Excel file in the database and then used the tables in
subsequent queries. I should add that I do write in vb as I am still
learning.

Any help is most appreciated.

 

[John W. Vinson]

The database is not yet created. In a previous db which was similar, I
manually linked each Excel file in the database and then used the tables in
subsequent queries. I should add that I do write in vb as I am still
learning.

So...? Are you ok with this or do you need more info?

 

[JE]

I will reference your suggestion on VBA code with the TransferSpreadsheet
method, however is there any other option other than VBA? Thank you.

 

[JE]

John, I have referenced information regarding TransferSpreadsheet and this
may work. Thanks for the assistance.