Tuesday, July 24, 2012

How to insert records from *.csv file to sql server 2005

sp_configure

sp_configure 'show advanced options', 1
reconfigure

sp_configure 'Ad Hoc Distributed Queries', 1

select * from [Customers_A-F]

insert into [Customers_A-F]
SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=D:\Temp\;','SELECT * FROM [Customers.csv]')