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.
Can I have a command / queries, which helping me to complete delete the table under the name "Sheet1xxxxx" ?
Thanks
Ricky.
Microsoft AccessSoftware
Last Comment
Rey Obrero (Capricorn1)
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"..
So I would like to make a queries or commands to delete this files.
Thanks.
So I would like to make a queries or commands to delete this files.
Thanks.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Drop Table Sheet1xxxxx
type that in the SQL view of a query and run