Linking Workbook and Overwriting Excel File

[Atheron]

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?

[alansidman]

Instead of creating a new file. Consider deleting the information in your file and then pasting the new data in. This might work.

Alan

[Atheron]

Hi Alan. Thanks for the info. I was wondering if I would need to do something like that. That should work since I have the ability to edit data in the Excel file and have it show in the Access db.

Do you (or anyone else) know why it wants to create a new link? There must be a unique property in the Excel file that Access looks at.