HOW TO READ EXCEL DATA DIRECTLY INTO SQL SERVER 2005?

Chris Anderson

Total Post:197

Points:985
Posted by  Chris Anderson
 1458  View(s)
Ratings:
Rate this:
  1. Chris Anderson

    Post:197

    Points:985
    How to read excel data directly into SQL server 2005?

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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!