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?

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?