Import CSV file to SQL server 2005

Q: How to import csv file in SQL server 2005?

A: It's simple. let i tell u...

BULK
INSERT  CDR (Table Name)
FROM 'E:\cdr\CDR\20091006.txt'  (path location on file)
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

Then press enter F5 to run query