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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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