Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    USA
    Posts
    21

    Smile Unanswered: Deleting contents from tables

    To All:

    I have a marge set of tables that take data in from an FTP server every day. I need to remove all data from these tables using a macro so the data stays as close to current as possible.
    Anyone have any thoughts on that?

    TIA
    Lakota

  2. #2
    Join Date
    Feb 2004
    Posts
    2
    This vb code will erase all records from the specified table.

    currentDB.Execute "DELETE * FROM tableName"

    Just replace "tableName" with the name of your table.

    I hope that helps.

  3. #3
    Join Date
    Dec 2003
    Location
    USA
    Posts
    21
    Originally posted by g00dfella
    This vb code will erase all records from the specified table.

    currentDB.Execute "DELETE * FROM tableName"

    Just replace "tableName" with the name of your table.

    I hope that helps.
    G00dfella:

    Getting operator missing error???
    ANy thoughts?


    Thanks
    Lakota

Posting Permissions

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