Import .CSV to SQL Table

BULK INSERT New_Table
FROM 'c:\csvfile.txt'  --or a .csv file
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

Yes, so gracefully simple…

Just create the table beforehand

~ by Francois Wiid on February 19, 2008.