Link to home
Start Free TrialLog in
Avatar of Rickyyy
RickyyyFlag for Hong Kong

asked on

Access Question

Dear Expert,
Can I have a command / queries, which helping me to complete delete the table under the name "Sheet1xxxxx" ?
Thanks
Ricky.
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

to delete a table

Drop Table Sheet1xxxxx

type that in the SQL view of a query and run
Avatar of Rickyyy

ASKER

actually, because i insert a table from excel. And maybe there are some error inside so it automatically create a import error table named "Sheet1$_ImportErrors" / "Sheet1$_ImportErrors1" /"Sheet1$_ImportErrors2"...etc...
So I would like to make a queries or commands to delete this files.
Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial