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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2010 append query to SQL is very slow 0
Append Query Issue 0
Access 2002 Append Query Problems 1
Append to two different tables 23
Numeric Field Overflow Error 5
Append to excel worksheet 1
update and append queries 1
Numeric Field Overflow when appending date - how to convert it to text 1

Back
Top