KB30385: When attempting to populate a temporary table in a Microsoft Excel database a 'Cannot modify the design of table XXX. It is in a read-only database' error is thrown.

SYMPTOM
When trying to populate a temporary table in Microsoft Excel, the error below is thrown:
 
 

 
Sample Code/Error
Cannot modify the design of table XXX. It is in a read-only database.
 
 
CAUSE
The Data Source Name used to connect to the Microsoft Excel database is set to Read Only, therefore its not possible to create a temporary table and write data into it.
 
ACTION

1. Open the ODBC Data Source Administrator located under Control Panel > Administrative Tools > Data Sources (ODBC).
2. Go to the System DSN tab and locate the DSN used to connect to the Microsoft Excel database and click Configure.
3. Select Options and uncheck the Read Only check box.