-
Is anyone aware of any commands for purging of a table in an access database? That is, I would like to delete all the data in it but not the structure. I am at the moment working between two tables and constantly need to clear data in them. So what I am doing now is killing the table and recreating them again. Surely there must be a way of purging the data without having to recreate the whole table. If anyone has any suggestions, I would greatly appreciate it.
Thank you.
Ben
[email protected]
-
Simple SQL
A simple SQL statement will do the job man.
"Delete from "+tablename.
That's it.
-
Thanks for that. I'm not actually too experienced with SQL and was looking in MSDN for help, but nothing like that came up. Only found how to kill a table.
Thanks again.