Rickyyy
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.
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.
So I would like to make a queries or commands to delete this files.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Drop Table Sheet1xxxxx
type that in the SQL view of a query and run