读取CSV,TXT文档

    技术2022-05-11  63

    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;            }          }  

    最新回复(0)