Results 1 to 3 of 3

Thread: Purging tables

  1. #1
    Guest
    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]

  2. #2
    Hyperactive Member
    Join Date
    Nov 1999
    Posts
    266

    Simple SQL

    A simple SQL statement will do the job man.
    "Delete from "+tablename.
    That's it.

  3. #3
    Guest
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width