Appending more than one Excel file in same directory to Access tab

C

C Jones

I have many excel files with the same format headers. I am trying to get all
files appended into 1 access table. Is it possible to run a script to import
all files in the directory and append them to one access database table.

I plan to run queries from the table.
 
M

[MVP] S.Clark

The TransferDatabase action allows for the specification of an Excel range.
So, the answer is Yes, but you'll have to execute the action one time for
each range.
 
Top