M
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!!
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!!