Import Multiple Excel sheets into a table

[mmorrison]

We have 26 files we need to import into a table. each time I have been right clicking on the table, import, select excel, select the file, upload, okay...repeat...

Is there any way I can select multiple excel sheets to simplify this process?

 

[the_net_2.0]

I ran across this in the faq section: http://www.access-programmers.co.uk/forums/showthread.php?t=158308

it might be useful...

 

[mmorrison]

Sorry that didnt really explain much, the download in the zip didnt have a table set up in it.

 

[vapid2323]

This might be best asked in the VBA section, as VBA will need to be used to solve this one.

Sorry I cant help much more than that