What is the best way to query a worksheet in an Excel 12.0 spreadsheet that resides either on a local drive or a network share that has spaces in the share as well as the filename from SQL 2005?
I have tried what seems like a gazillion methods but either run into ISAM errors or no data being pulled. The SQL server does not have Office installed if this makes a difference.
H E L P ! !