You can use ADO to send an SQL command to append your Excel data to an Access
table. I have written a couple responses to other posts in the past week to
this same issue; if you do a search for Dales Access I think you will find
the info you need; if not let me know and I will post the info again for you.
--
- K Dales


"Jof" wrote:

I need to export data from excel into access. I cant link the file from
access, as the excel data is saved in a different location everytime.

I run a macro to format the data, and would like the VBA code to append
the data into an access table at the end of this formatting code.

I can import the files but cant automate it from access as the file
path is different everytime.

Any ideas?