how Import /read CSV File with Different - different encoding

Question

I am trying to read / import CSV into data set with Following code

if (!File.Exists(file))
{
    File.Create(file).Close();
}

OleDbConnection connection = new System.Data.OleDb.OleDbConnection(
    "Provider=Microsoft.ACE.OLEDB.12.0; Data Source = " + Path.GetDirectoryName(file) + 
    "; Extended Properties = \"Text;Excel 12.0;HDR=" + _AllowHeader + ";FMT=Delimited\"");

connection.Open();

string Query = "Select " + Count + " from [" + Path.GetFileName(_filename) + "]";

OleDbDataAdapter Adaptar = new System.Data.OleDb.OleDbDataAdapter(Query, connection);
Adaptar.Fill(DataSet);

It is fine With ANSI Encoded csv file as I can Import, but when I try to import UTF-8 or Unicode (Encoded) CSV File I got Byte Order Mark (BOM) in column Name.

My question is how can I prevent this and import any encoded CSV File?

possible duplicate of Read Csv file encoding error

Russ Clarke
– Russ Clarke

2011-09-16 11:34:44 +00:00
Commented Sep 16, 2011 at 11:34 — Russ Clarke
– Russ Clarke, Commented Sep 16, 2011 at 11:34
Please try and keep your code readable!

Justin
– Justin

2011-09-16 12:45:41 +00:00
Commented Sep 16, 2011 at 12:45 — Justin
– Justin, Commented Sep 16, 2011 at 12:45

Kane · Accepted Answer · 2011-09-16 11:36:09Z

1

You are probably better of using something other than Jet / Ace drivers to read or parse CSV data. At work we use this free library: http://www.filehelpers.com/

Looking at the documentation it appears to support different encoding types.

answered Sep 16, 2011 at 11:36

Kane

16.8k11 gold badges67 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how Import /read CSV File with Different - different encoding

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related