用ODBC导入csv文件和txt文件(但是文件的名称中不能有点".")

 

  private void FormImport_Load(object sender, EventArgs e)
        {
            DataSet dst= subImportCsv_Dataset("d:\\","syncml_contacts.csv");
            this.dataGridView1.DataSource=dst.Tables[0];
           
        }

      public DataSet subImportCsv_Dataset(string filePath, string fileName)
     {
             string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=";
            strConn += filePath;//这个地方只需要目录就可以了                                                      
            strConn += ";Extensions=asc,csv,tab,txt;";
            OdbcConnection objConn = new OdbcConnection(strConn);
            DataSet ds = new DataSet();
             try
              {
                 string strSQL = "select * from " + fileName;//文件名，不要带目录
                  OdbcD