delete after OutputTo

M

mate

I have a macro that sends the output of a table to an
excel spreadsheet. Is there a way to have all the records
in that table deleted after the outputTo? I don't want to
delete the table though. any help would be great.
thanks, mate.
 
W

Willy

Mate
Create a delete query that deletes * from that table. and set the macro to run tha
query right after your outputto
Will

----- mate wrote: ----

I have a macro that sends the output of a table to an
excel spreadsheet. Is there a way to have all the records
in that table deleted after the outputTo? I don't want to
delete the table though. any help would be great.
thanks, mate
 
Top