CODEWITHSUNDEEP
vb.netcsvdata-import
Tracy
Tracy

Reputation: 15

import csv to sql

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.

Upvotes: 0

Views: 1912

Answers (1)

Jeremiah Willcock
Jeremiah Willcock

Reputation: 30999

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.

Upvotes: 1

Related Questions