I am trying to write an SQL statement in the format:
SELECT * INTO <Target> FROM <Source>
which will run against an ADODB.Connection to a SQL server database.
For my Target, I am trying to use the string:
but I'm always getting the error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Specified owner name 'Excel 8.0;HDR=Yes;DATABASE=C:\Temp.xls' either does not exist or you do not have permission to use it.
There is no question that the Spreadsheet exists, and at present it's just a new workbook created on my machine by me with field names in it, so there shouldn't be any problem with permissions.
The source is just a table name in the SQL server database.