Excel – a read-only database?

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.”.

How to Do Everything with Microsoft Office Access 2003 (How to Do Everything)

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.

4 thoughts on “Excel – a read-only database?”

  1. […] I found the following link to be useful: Protean � Blog Archive � Excel – a read-only database? This link says, “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.” […]

Leave a Reply to DTS from MS SQL to Excel Spreadsheet Issue - dBforums Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.