Deleting error tables automatically

[Martyn]

Ihave queries which import excel information into table
structures allready set up No problem but the excel data
is in grouped fancy presentation layout with groups and
repeated headers I DONT want to play around with excel data
The import works fine except where headers and space rows
then creates import error files I know what these are they
are not important at all
Question is is there a query or method I can write that
will delete all tables containing this '.....error' word
automatically as they will mount up over time and make
database larger and confusing.I know I can go in back end
to reveal tables but dont want this I am using Access 97

In effect I want a query that will delete all tables
ending or containg the word error!!

 

[[MVP] S. Clark]

There is no query that will delete anything but data from a table.

You can write VBA code to step through the tables and delete anything with
the word Error in it.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-