Hi,

I am writing a couple of macros in Access 2007 to add data within a table and empty the data from the table as well.

I have managed to write a "TransferSpreadsheet" to add the data but don't know how to write one to empty the table (leaving the headers in). Would i need to write a query or is there an action item that will let me do this.

Could somebody please help.

thanks in advance.

aftabn10

You could try the RunSQL action.