What I suggested was running a macro creatd in Excel through Sendkeys to delete records. My assumptions was that the spreadsheet is not linked to the database and data is imported into Access at different intervals.
And it works!
I guess what can be done is run Excel through Access itself and with Sendkeys run excel-macro which deletes the data and quits excel.
I hope it helps
rk
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.