You can use this property to enforce read-only access to Microsoft Excel from the provider.

Data Type

bool

Default Value

false

Remarks

If this property is set to true, the component will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.