Deleting data in a linked excel sheet

[zevw]

In my database I link to an excel sheet where I append the data into my table. After the append is done I would like to delete the data from the excel sheet, so that it is not imported again. I get a message that I cannot delete linked data what can I do so that it is deleted.

I cannot delete the sheet because the user will need the format of this sheet for new data entered later.

Thanks in advance for you help.

 

[PHV]

I cannot delete the sheet because the user will need the format of this sheet for new data entered later
Why not using a template (.xlt) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[zevw]

To be honest I do not know how to use an xlt.

Is there another way around?

 

[flyover789]

You could run an update query on the linked sheet, setting the values to Null. Note that this won't work for cells with formula.

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]

 

[tbassngal]

I would also use a template, but flyover789's example sounds like the trick. You might also try to write a macro in your Excel spreadsheet that is ran when Access prompts it to run. You should be able to delete data using Excel macros prompted by MS Access Module.