Protean

If you are trying to execute some Jet SQL DDL like CREATE TABLE or DROP TABLE against an Excel workbook and you get this message:

Executing the query “DROP TABLE [Sheet1];” failed with the following error: “Cannot modify the design of table ‘Sheet1′. It is in a read-only database.”.

Check your connectionstring properties in your excel connection manager. If you have the extended property “IMEX=1″, then you will be opening your workbook in import mode and therefore you will be unable to modify the design. Remove the setting and you may find that your Execute SQL task now works.

This entry was posted on Tuesday, April 1st, 2008 at 3:29 pm and is filed under Nuggets, SSIS, Fixes, SQL Server 2005, Jet 4.0. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.