Reading Excel file in SQL Server

pankaj_254768

4.31/5 (8 votes)

Jan 18, 2011

CPOL

64922

Shows how to read an Excel file using SQL query commands from SQL Server

Syntax:

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
          'Excel 8.0;Database=<FILE_PATH>',
          'SELECT * FROM [Sheet1$]')

Example:

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