Jump to content


Check out our Community Blogs

MiniEmmy

Member Since 28 Sep 2012
Offline Last Active Oct 13 2012 01:30 AM
-----

Posts I've Made

In Topic: Importing CSV files Into Database

28 September 2012 - 11:23 AM

My application deals with parsing user entered text that is stored as a csv file and I found issues this week regarding wrongly entered quotation marks. I have now ended up using this c# library and it works very well: http://kbcsv.codeplex.com/ not sure what it does with ,, but it should be worth a try. Got my csv file into a dataset in three lines of code no problem. And with if you wanted to store it in a sql you can use the bulkcopy method. (I use SqlExpress)

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download