After Importing Records from Excel Delete Records in Excel

[itemus]

Here is what I want to accomplish:

I have a button that imports data from an Excel spreadsheet. This spreadsheet is updated by numerous users from different locations. I want to be able to import the data from the spreadsheet into Access and then delete the data (keeping the column headers) in the Excel spreadsheet to start all over again. Can this be done without opening the Excel spreadsheet?

Thanks.

John

 

[rahulk65]

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

 

[tlbroadbent]

You can't delete rows directly from Access. However, you can update rows in a linked Excel spreadsheet. If you link the spreadheet then just create a query that sets all the columns in the spreadsheet to NULL. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[rahulk65]

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!