SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server
select * from OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\myfile.xls', 'select * from [Sheet1$]')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)