How to read excel data directly into SQL server 2005?

Chris Anderson · 2011-08-12T01:56:56.000Z

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

Services

Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Career

Apply Job Internship

interview