append multiple spreadsheets

E

Eric W.

I have a form. I want a command button that will append
all Excel files from a specific directory into my access
table. Say that my Excel directory is C:\My Documents and
my Access table is called test. Any help is greatly
appreciated. Thanks in advance!

Eric W.
Madison, WI
 

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

Mail Merge Directory Conditional Page Break 0
Embed the same Excel multiple times 0
OLE link 0
Add current record to table 7
how do i get records to append to multiple tables 2
Append Query to Mainform and Subform 0
Access 2010 DB not fuctional with multiple users 2
Help needed passing data from the form to a table. 0

Top