Hi all! Thanks for taking the time to read this.
I use an online software to process customer transactions. I export the transaction data to an Excel file, import the file to Access, and then use Access to create reports and receipts.
Here's what I would like to do:
Instead of importing the file to Access, I would like to create a link to the Excel file. Creating the link is no problem. The problem comes in when I want to overwrite the Excel file with a new file. Even though I name the file the same name, etc, Access make me create a new link to this new file.
Is there a way to overwrite the linked Excel file without creating a new link from Access?