need to update querries to link to a new excel file which replaces previous one.

So I have to download the current version of our inventory from an external website which prevents me from just making a linked table that updates as we update the excel file. My goal is to create an import script which will take the new file, replace the old file and still maintain all the query links. they should be mostly identical but there will be some difference in quantity data or total items if we got a new product in.

as it stands i have been just remaking querries every week as i update the current downloaded version of inventory.

anyone have suggestions for how to update this process to be more automatic?

download the excel file to the same place everytime, i.e.: c:\temp\File2Import.xls
overwriting it each time.
link this as an external table.
build an append query to import the data from the xl file.
put this query in a macro.

then the steps are:
1. save the file,
2. run the macro.
done.

I have already tested. It works

Done. thank you