Importing CSV file to Sql server

Question

0.00/5 (No votes)

See more:

I wish to build and application with c# that will upload a single csv file from different source and map it to about 4 tables in sql server database. Can some one help me pls...am really new in the whole stuff

Posted 16-Aug-10 13:46pm

Amaka123

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

gaurav_verma_mca · Answer 1 · 2010-08-16T13:54:00

This should be very simple to do and you have a whole bunch of options to do it.

1. The CSV will have a specific format, which will map to your tables.

1. First you need to decide how you will upload the CSV into an object structure which can be passed to the Sql Server. There are a bunch of options here
a. You can treat your CSV as a data source and upload it into a Data Set or object data source
b. You can write a custom DTO, parse the file manually and then convert it into your desired list of objects.

2. Next you will have to transfer this data in bulk to the SP or if you dont want to use a SP then call an insert query multiple times. Here you can use Table value parameters, Convert your entity to XML and send it for bulk update or insert one row at a time

Thats it...

In case you are not so hung up on C# then you may use SSIS wizards which will allow you to do the same job with drag and drops

gmtzgtz · Answer 2 · 2011-10-13T14:08:00

Solution 3

You can do this from T-SQL using the below statement:

SQL

bulk insert [dbo].[Courses]
from 'C:\Courses.csv'
with (fieldterminator = ',', rowterminator = '\n')
go

For additional info go to: Import a CSV File to SQL Server

Posted 13-Oct-11 14:08pm

gmtzgtz