MDAC 2.5 SDK - ODBC Desktop Database Drivers


 

DROP TABLE Statement Limitations

When the Microsoft Excel 5.0, 7.0, or 97 driver is used, the DROP TABLE statement clears the worksheet but does not delete the worksheet name. Because the worksheet name still exists in the workbook, another worksheet cannot be created with the same name.