csv

public static Boolean KWHitsUseUTF16;
        public static Boolean AllFilesUseUTF16;
        public static void importData()
        {


            data.keywordHits = new DataTable();
            data.allFilesListing = new DataTable();
            DataTable tmpTable = new DataTable();

            if (KWHitsUseUTF16)
            {
                CSVOleDb kwreader = new CSVOleDb();
                keywordHits = kwreader.GetDataTable(data.kwfile);
            }
            else
            {
                using (CsvReader csv = new CsvReader(
                               new StreamReader(kwfile), true))
                {
                    csv.MissingFieldAction = MissingFieldAction.ReplaceByEmpty;
                    keywordHits.Load(csv);
                }
            }

            if (AllFilesUseUTF16)
            {
                CSVOleDb allfilereader = new CSVOleDb();
                tmpTable = allfilereader.GetDataTable(data.AllFilesFile);
            }
            else
            {
                using (CsvReader csv2 = new CsvReader(
                               new StreamReader(AllFilesFile), true))
                {
                    csv2.MissingFieldAction = MissingFieldAction.ReplaceByEmpty;
                    tmpTable.Load(csv2);
                }
            }
            //allFilesListing = FixFTKSizes(tmpTable);
            allFilesListing = tmpTable;
        }

    }


    #region CSVOleDBMethod
    // Uses Excel-type logic to easily load CSV files.
    class CSVOleDb
    {
        public System.Data.DataTable GetDataTable(string strFileName)
        {
            System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection
            (
            "Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + System.IO.Path.GetDirectoryName(strFileName) +
            "; Extended Properties = \"Text;characterset=Unicode;HDR=YES;FMT=Delimited\""
            );
            conn.Open();
            string strQuery = "SELECT * FROM [" + System.IO.Path.GetFileName(strFileName) + "]";
            System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter(strQuery, conn);
            System.Data.DataSet ds = new System.Data.DataSet("CSV File");
            adapter.Fill(ds);
            return ds.Tables[0];
        }
    }
    #endregion