Delete all rows then append

[Ste4en]

I need to append some rows into a table, before I add these rows i need to delete all of the old rows.

I can't use a Make Table query because I am updating a linked table in another database.

So how can I (automatically) delete all rows in that table before or during the append process.

Thanks
Steve

 

[boblarson]

Create a delete query and just select the asterisk and put in no criteria, or use:

Dim strSQL as String

strSQL = DELETE * FROM YourTableName
DoCmd.RunSQL strSQL

 

[Ste4en]

thanks worked fine.