读取CSV，TXT文档

public DataSet GetDataSetFromCSV(string filePath, string fileName)
        ...{
            string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=";
            strConn += filePath;                                                        //filePath, For example: C:
            strConn += ";Extensions=asc,csv,tab,txt;" ;
            OdbcConnection objConn = new OdbcConnection(strConn);
            DataSet dsCSV = new DataSet();
            try
            ...{
                string strSql = "select * from " + fileName;                     //fileName, For example: 1.csv
                OdbcDataAdapter odbcCSVDataAdapter = new OdbcDataAdapter(strSql, objConn);
                odbcCSVDataAdapter.Fill(dsCSV);
                return dsCSV;
            }
            catch(Exception ex)
            ...{
                throw ex;
            } 
        }

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/angel_n/archive/2007/02/26/1515258.aspx