I originally setup the connection as Direct Connection using ODBC and Data Source Driver as Microsoft Excel 2007/2010
I read the post about checking the ODBC and making sure it isn't set to Read-Only
I found my ODBC was not:
But the error persisted.
Any thoughts on which modifications I should make to write to the Excel file? I know writing to Excel in general is bad practice. Their spreadsheet will be phased out eventually with custom SQL Tables I am building.