Is there a way to use Excel Connection Manager with OpenRowSet
when the worksheet has a space in the name (e.g. "My Sheet"). I am using SQL Server 2008R2.
OpenRowset works fine without spaces in the worksheet name, but generates an error when a space is present. I have tried multiple [] and ' ' combinations to bracket the worksheet name.
JG4 documented the same problem in a posting titled "Skipping leading rows in Excel"
(at the bottom of the thread):
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/97144bb2-9bb9-4cb8-b069-45c29690dfeb
View Complete Post