append multiple excel files to access table

  • Thread starter Thread starter Ron R
  • Start date Start date
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?
 
Back
Top