import csv to sql

Question

I have to import an csv file to SQL database table which already created (empty and has the same number of named columns). It would be great if you could suggest any tutorials or give some tips.

Which database are you using and which version? SQL Server 2008? — John Saunders
– John Saunders, Commented Feb 26, 2011 at 4:23

Community · Accepted Answer · 2017-05-23 12:19:53Z

1

I assume you are using Microsoft SQL Server. Do you need to do this in a program or manually? There is a tutorial on using the bcp command for that, or alternatively a SQL command. If you need to parse the CSV file for your own code, see this previous SO question.

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Feb 26, 2011 at 4:26

Jeremiah Willcock

31.3k8 gold badges81 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tracy Over a year ago

Thank you very much.Is there a different way to do this? My CSV file contains last column which is one of three words(insert,update or delete). According to this I need or insert CSV file to the datatable or update or delete records. And what is the best way to know what is the data("word") in this row in this column? Thank you in advance.

Jeremiah Willcock Over a year ago

@RedHelen: You might need to load the CSV file into your program and then have that update the database. Look at the last link in my answer for directions on how to do that.

Collectives™ on Stack Overflow

import csv to sql

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related