Read alphanumeric characters from csv file in C#

Question

I am using the following code to read my csv file:

public DataTable ParseCSV(string path)
    {
        if (!File.Exists(path))
            return null;

        string full = Path.GetFullPath(path);
        string file = Path.GetFileName(full);
        string dir = Path.GetDirectoryName(full);

        //create the "database" connection string 
        string connString = "Provider=Microsoft.ACE.OLEDB.12.0;"
          + "Data Source=\"" + dir + "\\\";"
          + "Extended Properties=\"text;HDR=Yes;FMT=Delimited\"";

        //create the database query
        string query = "SELECT * FROM " + file;

        //create a DataTable to hold the query results
        DataTable dTable = new DataTable();

        //create an OleDbDataAdapter to execute the query
        OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString);

        //fill the DataTable
        dAdapter.Fill(dTable);

        dAdapter.Dispose();

        return dTable;
    }

But the above doesn't reads the alphanumeric value from the csv file. it reads only i either numeric or alpha.

Whats the fix i need to make to read the alphanumeric values? Please suggest.

Answer 1

I suggest you use A Fast CSV Reader which does not have this issue and is much more faster.

Answer 2

Remove IMEX=1 from the connection string. I don't think you need it for CSV files.

Answer 3

Try this OleDBAdapter Excel QA I posted via stack overflow.

I have not tried this out, but it sounds interesting! LinqToExcel they say it can be used on .CSV files as well...

Answer 4

hi all this code is gets alphanumeric values also

using System.Data.OleDb;

string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filepath + ";" + "Extended Properties="+(char)34+"Excel 8.0;IMEX=1;"+(char)34;

        string CommandText = "select * from [Sheet1$]";

        OleDbConnection myConnection = new OleDbConnection(ConnectionString);
        myConnection.Open();

        OleDbDataAdapter myAdapter = new OleDbDataAdapter(CommandText, myConnection);

        ds = null;
        ds = new DataSet();
        myAdapter.Fill(ds);