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
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
