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):
View Complete Post