Kamis, 09 Agustus 2012

[MS_AccessPros] Access SQL Syntax for a Query to Drop a Table

 

I have a table that I would like to drop, if it exists.
I have a query that drops several tables. All, but one exists whenever this query is called from a macro. The [Sheet1$_ImportErrors] may or may not be there.

drop table tblTmpTblDailyDevconImport,
tblTmpTblDailyCoachOnHoldImport,
tmptblDailyOBSCommCoachImport,
tblTmpTblDailyVehicleAssign,
tblTmpTblDailyINITArchives,
[Sheet1$_ImportErrors];

Thanks for any suggestions
Terryomsn

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar