Dropping table with certain table criteria

**MTSPEER** · 08-30-2017, 02:49 PM

Hello,

I need help writing SQL code to drop all tables that contains "ImportErrors" in it. Is there a way this can be done to delete all tables that have this criteria?

thanks

**pbaldy** · 08-30-2017, 03:17 PM

See if this gets you going:

http://access-excel.tips/access-vba-...gh-all-tables/

**MTSPEER** · 08-30-2017, 03:55 PM

I still don't know what criteria would go into the loop

**pbaldy** · 08-30-2017, 03:58 PM

If tdf.Name Like "*ImportErrors*" Then

**MTSPEER** · 08-30-2017, 07:19 PM

If tdf.Name Like "*ImportErrors*" Then
DROP TABLE tdf.Name

That's what I'm guessing.

**pbaldy** · 08-30-2017, 08:04 PM

Did you notice the link at the bottom?

**MTSPEER** · 08-31-2017, 06:32 AM

Sorry I did not notice the link at the bottom. I got it now. Thanks!

**pbaldy** · 08-31-2017, 08:01 AM

No problemo!

Dropping table with certain table criteria

Thread Tools

Dropping table with certain table criteria

Similar Threads

Query to list all results from table 1 with criteria from table 2

change value in a table based on criteria from a different table

Data Validation in a Table using criteria from another Table

Using another table as a criteria for a make table.

Use table value for query criteria & table name

Posting Permissions