Reading Excel file in SQL Server

pankaj_254768

Rate me:

4.31/5 (8 votes)

17 Jan 2011CPOL

64K

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

Syntax:

SQL

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

Example:

SQL

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

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

pankaj_254768

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Reading Excel file in SQL Server

License

Comments and Discussions