append multiple excel files to access table

R

Ron R

I have a table which contains 65 fields, on a regular
basis there is a need to append multiple excel files with
the same number of matching fields. Each excel file has
an incremental name (ex. file1.xls, file2.xls, etc etc)
How can I append these multiple excel files to my access
2000 database using a command button?
 

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

Append csv or xls file to existing table 3
Access Append Querry 3
Append a copy of records in excel to access table using a button 1
Refreshing Data Daily From a Linked Excel Spreadsheet 2
Importing excel into access 2
Subscript out of range messge while importing from Excel to append 8
Import Excel Workbook from Sharepoint 4
How to create .pdf dummy files from .xls using batch file 1

Top