Hi Perico,

Interesting, Ed. (I still wish MS made it easier.) I use the
transferspreadsheet method to pull the data into Access. Would your
technique work with that? What does you code look like setting up and
breaking the link?

With my method there is no need to use code. I just leave the link in Access
and replace the Excel Workbook as necessary.

Yes, the method would work if you use the TransferSpreadsheet method

Code would be;


DoCmd.TransferSpreadsheet acImport, 8, "ExcelLink", "C:\myPath\myBook.xls",
True, ""
DoCmd.OpenQuery "qryDelDummy"

Where the query qryDelDummy is something like

DELETE *
FROM ExcelLink
WHERE ExcelLink.[account number] Like "xxxx*"

Hope this helps.

If you wish to continue this thread, perhaps the access newsgroup might be a
better place?

Ed Ferrero