Home > DeveloperSection > Interviews > How to read excel data directly into SQL server 2005?

Posted on    August-12-2011 1:56 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  1270  View(s)
Rate this:

Chris Anderson
Chris Anderson

Total Post:197

Points:985
Posted on    August-12-2011 12:00 AM

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


Don't want to miss updates? Please click the below button!

Follow MindStick