Table Linked to Excel Spreadsheet

[MGW1138]

I have a database linked to an Excel Spreadsheet. This Sheet is created / deleted / recreated by our network SQL Server Database at random times. I need to know how to a) detect that the Spreadsheet (effectively a transaction file) has had the link broken and b) force the re-establishment of the link automatically. Once this link is reestablish I can process the transaction file. If there is a way to automatically relink the sheet that would be great but I still would need to know how to detect that the relink had been done in order to process the transaction file.

Thanks


Michael

[ranman256]

the link should never break.
If you keep writing the excel data to the same excel file everytime, the data will self refresh.

[pbaldy]

One thought that comes to mind is checking the date modified of the file:

https://www.techonthenet.com/access/...ledatetime.php

You'd have to store it when you link to it, then check it periodically to see if it's changed. if so, relink and update the stored date/time.