0

sheet name formatting for openrowset excel access

I had difficulty finding any documentation for formatting the sheet name when using the OLEDB ACE engine to access an Excel file. I had originally attempted the following query: SELECT * FROM OPENROWSET(’Microsoft.ACE.OLEDB.12.0′, ‘Excel 12.0;HDR=YES;Database=C:\Report Output.xlsx’, sheet1$)SELECT * FROM OPENROWSET(‘Microsoft.ACE.OLEDB.12.0’,… Continue Reading