Cleaning Off Tables

  • Thread starter Thread starter Noah
  • Start date Start date
N

Noah

I have some tables in a database that I refresh every week
or so. I use a macro to import text files into these
tables. However, the data I import in is appended to the
existing data in the table. I would like to REPLACE the
existing data.
I thought about creating a delete query to do this and
then runing those queries in a macro. That would work but
before it deletes the contints of that table, it asks you
if you want to delete it. I have over 30 tables so that's
not a good idea.
So, does anyone know how to replace data in a table by
importing it or some way to clean out a table.
Thanks
 
See the post a few before yours for "Frank" it says to
set the SetWarnings to Off. You may be able to do this
for your macros with delete queries.
 
Back
Top