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?
Bookmarks