Using OpenRowset to query an excel Spreadsheet 1

[klewis10367]

Does anyone know the sntax for an Openrowset trying to query anExcel Spreadsheet. I am using SQL 2000.

 

[SQLDenis]

SELECT * FROM OPENROWSET( 'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls','SELECT * FROM [Sheet1$]')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[klewis10367]

Thank you that worked.