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?