title: Quotes in between a csv column text cause skipping of remaining columns while importing csv data
body: <p>I am using the following code to fetch data from a csv file:</p>
  
  <pre><code>    public DataTable GetCSVData(string CSVFileName)
      {
          string CSVConnectionString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + ConfigurationSettings.AppSettings["CSVFolder"].ToString() + ";Extensions=asc,csv,tab,txt;Persist Security Info=False;";
  
          using (OdbcConnection Connection = new OdbcConnection(CSVConnectionString))
          {
              DataTable CSVDataTable = new DataTable();
  
              string SelectQuery = string.Format(@"SELECT * FROM [{0}]", CSVFileName);
  
              OdbcDataAdapter Adapter = new OdbcDataAdapter(SelectQuery, Connection);
  
              Adapter.Fill(CSVDataTable);
  
              return CSVDataTable;
          }
      }
  </code></pre>
  
  <p>The exact problem is if a csv column contains a data, which is highlighted in bold letters,shown in Row1 below</p>
  
  <p>Row1-> col1,<strong>"cdwdf" dsdfs</strong>,col2,col3</p>
  
  <p>the col2 and col3  (columns after the highlighted text) are skipped while fetching the data using the above code and it continues with fetching data from the next row.</p>
  
  <p>If the mentioned column text in Row1 is fully within quotes (<strong>"cdwdf dsdfs"</strong>) the data is fetched correctly.</p>
  
  <p>Any one please tell me how to fetch data from csv in such a situation...</p>