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

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

thanks worked fine.