Documentation for--> DoCmd.RunCommand acCmdDeleteTable ?

[NU_Dave]

I've automated a table import to create "MyTable". It works fine, and it
also causes the creation of an "MyTable_ImportErrors" table with any import
problems.

I want to delete "MyTable_ImportErrors" (if it exists) before I execute the
import.

I believe the answer will be in "DoCmd.RunCommand acCmdDeleteTable" but I
can't find sufficient documentation about how to use it.

Suggestions?

 

[Albert D. Kallal]

Use sql commands:

try:

CurrentDb.Execute "drop table NameOfYourTable"\

 

[Albert D. Kallal]

bumped send key..you don't need that "\"

eg:

CurrentDb.Execute "drop table NameOfYourTable"

 

[NU_Dave]

Never mind!

I was able to do what I needed with;
DoCmd.RunSQL "drop table [MyTable_ImportErrors]"

 

[NU_Dave]

Excellent! Thank you for your response.

Dave