Is there a "proper" way to read CSV files

c# .net csv oledb
Gareth picture Gareth · Jul 9, 2009 · Viewed 14.5k times · Source

Possible Duplicate:
CSV File Imports in .Net

In .net, is there a standard library that should be used to read in csv files? All the samples on the web roll their own csv reader / parser, or use OleDb.

It's not a problem using any of these solutions, I was just wondering if there is a generally accepted library (not that I can find), or any other "proper" way to do it?

Answer

Marc Gravell picture Marc Gravell · Jul 9, 2009

CsvReader is a pretty good one... it isn't Microsoft, but it works very well, and is a lot faster than some of the alternatives (legacy OleDb etc).

Related questions

When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?

In my C# application I am using the Microsoft Jet OLEDB data provider to read a CSV file. The connection string looks like this: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Data;Extended Properties="text;HDR=Yes;FMT=Delimited I …

Read More
Reading Comma Delimited Text File to C# DataTable, columns get truncated to 255 characters

We are importing from CSV to SQL. To do so, we are reading the CSV file and writing to a temporary .txt file using a schema.ini. (I'm not sure yet exactly why are are writing to this temporary file, …

Read More
OleDB not supported in 64bit mode?

I've been using Microsoft.Jet.OLEDB.4.0 and Microsoft.ACE.OLEDB.12.0 to read in .csv, .xls, and .xlsx files. I just found out that neither of these technologies are supported in native 64bit mode! I have 2 questions: What is the supported …

Read More