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

Top