How to import data from .csv file into a table in sql server using bcp in/out

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » How to import data from .csv file into a...

How to import data from .csv file into a table in sql server using bcp in/out

Rate Topic

Display Mode

Topic Options

Author

Message

arthi.anan

Posted Tuesday, October 30, 2012 3:25 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 6:23 AM
Points: 20, Visits: 55

Hi experts,
I have a .csv file from which i have to do bcp out and bcp in, in command prompt and store the data into a table called temp.

How do i get the data into the table from a .csv file?
I have created the datafile and format file for temp.
How to get the values from .csv file and do bcp in to load it into the table 'temp'?
Please help me
Thanks in advance

Post #1378633

bicky1980

Posted Tuesday, October 30, 2012 4:34 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, February 21, 2013 7:38 AM
Points: 211, Visits: 378

I personally use a Bulk Insert statement:

BULK INSERT [tablename]
from '[Full File Path]'
WITH ( BATCHSIZE = 100000, FIELDTERMINATOR = ',' )

Post #1378666

arthi.anan

Posted Tuesday, October 30, 2012 4:47 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 6:23 AM
Points: 20, Visits: 55

Thanks for ur reply
but i wanted to import using bcp instead of bulk insert...

Post #1378674

anthony.green

Posted Tuesday, October 30, 2012 5:26 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

What is the reasoning on using BCP?

But if you have the format file and the data in a csv format, all you need to do is build a BCP command using this link as a reference (http://msdn.microsoft.com/en-us/library/ms162802.aspx) with the right switches to import the data.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1378698

OTF

Posted Wednesday, October 31, 2012 8:22 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 6:34 AM
Points: 254, Visits: 3,716

arthi.anan (10/30/2012)

Thanks for ur reply
but i wanted to import using bcp instead of bulk insert...

There may, of course, be specific reasons for your choice though do bear in mind that Bulk Insert is typically faster and neater especially if used from within a Stored Procedure.

Post #1379342

« Prev Topic | Next Topic »

Permissions