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
 
Top