Reading csv file into DataTable

Question

I'm Korean and I have a problem regards with importing csv file into DataTable.

I used this code to import csv file.

    public static DataTable ParseCSV(string path)
    {
        string filePath = Path.GetDirectoryName(path);

        string oledbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"text;HDR=Yes;FMT=Delimited\"";

        string csvFileName = Path.GetFileName(path);

        string sQuery = string.Format(" SELECT * FROM [{0}] ", csvFileName); 
        DataTable ds = null;

        OleDbDataAdapter adt = null;

        using (OleDbConnection con = new OleDbConnection(oledbConnectionString))
        {
            ds = new DataTable();
            adt = new OleDbDataAdapter(sQuery, con);
            adt.Fill(ds);
        }

        return ds;
    }

It works very well when there is no Korean language in csv file.

However, if csv file contains korean word, it transfers korean word into some strange word.

I need your help.

Thank you~~~

Have you tried this: plugins.jquery.com/project/csv

lang2
– lang2

2011-07-25 08:41:59 +00:00
Commented Jul 25, 2011 at 8:41 — lang2
– lang2, Commented Jul 25, 2011 at 8:41

sudheshna · Accepted Answer · 2011-07-22 05:29:44Z

1

Please try the following parser,

http://www.codeproject.com/KB/database/CsvReader.aspx

answered Jul 22, 2011 at 5:29

sudheshna

1,1601 gold badge14 silver badges24 bronze badges

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

Comments

Edgar Velasquez Lim · Accepted Answer · 2011-07-22 05:28:00Z

0

Save your csv file with UTF-8 encoding. This will more than likely solve your problem. You can use notepad++ to quickly convert your already saved file to UTF-8, run the import and see if that is working.

edited Jul 22, 2011 at 5:28

answered Jul 22, 2011 at 5:22

Edgar Velasquez Lim

2,44418 silver badges15 bronze badges

1 Comment

장선민 Over a year ago

Thank you for your reply. However, I already saved file to UTF-8 and I also tried convert this to UTF-8, my problem is not resolved.

YAYAYAYA · Accepted Answer · 2012-08-09 11:04:45Z

0

It happens to me. and i find that file that saved into utf-8 is the problem. you need to save the file as ANSI using notpad or what ever. then if you still have problem you need to add this row depand on the lenguage you need.

dataTable.Locale = CultureInfo.CurrentCulture;

or

dataTable.Locale = CultureInfo.GetCultureInfo(your culture);

here is the codes for the culture info.

http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo%28v=vs.71%29.aspx

answered Aug 9, 2012 at 11:04

YAYAYAYA

4143 silver badges3 bronze badges

Collectives™ on Stack Overflow

Reading csv file into DataTable

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related