Loading

How to import a csv file and save it to sql server

Andile Choko

15y1.9k.NET

Hi Fellow Programmers,

I'm trying to import a csv file and save its contents to the database; How can i achieve that in c# (Web application);

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
Your question is asking two things. How to read a CSV file is separate from how to insert data into a database. The question of how to read a CSV file is asked so often that people have written articles about it. Just look at the articles listed under "Our recommended articles" at the right side of this page. Also look for other relevant articles. Also look for articles about inserting data into a database.
0
Vulpes15y ago
Check out this thread:

http://www.c-sharpcorner.com/Forums/Thread/139577/how-to-parse-a-text-file-in-C-Sharp-net.aspx
0