title: Trouble importing/replacing a table w CSV in phpMyAdmin: Invalid column count in CSV input on line 1
body: <p>I am trying to swap out a table in phpMyAdmin with new data.
  I have scoured the web trying to find an answer to my issue but with no luck.
  I am not sure if the issue is somewhere in my CSV or in the phpMyAdmin import settings.</p>
  
  <p>Here is an example of the first two lines of my CSV file that I am trying to import...</p>
  
  <pre><code>'CA1923', '6320 Canoga Avenue', '', '6320 Canoga Avenue', NULL, 'Woodland Hills', 'CA', '91367', 'USA', NULL, NULL, NULL, 'info@connexusvideo.com', NULL, NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '0', 'http://www.google.com/mapfiles/markerN.png', '-118.5961599', '34.1851569', '12', '8', '42', '1', '0', '6320 Canoga Avenue Woodland Hills CA', '6320 Canoga Avenue Woodland Hills CA', '0', 'CA1923', '0', '6', '0',
  'CA1927', '425 Market Street', '', '425 Market Street', NULL, 'San Francisco', 'CA', '94105', 'USA', NULL, NULL, NULL, 'info@connexusvideo.com', NULL, NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '0', 'http://www.google.com/mapfiles/markerN.png', '-122.3981953', '37.7912401', '12', '8', '42', '1', '0', '425 Market Street San Francisco CA', '425 Market Street San Francisco CA', '0', 'CA1927', '0', '7', '0',
  </code></pre>
  
  <p>Here is the column headers exported out of the SQL file for this table...</p>
  
  <pre><code>INSERT INTO `conx_gmapfp` (`id`, `nom`, `alias`, `adresse`, `adresse2`, `ville`, `departement`, `codepostal`, `pay`, `tel`, `tel2`, `fax`, `email`, `web`, `img`, `album`, `intro`, `message`, `horaires_prix`, `link`, `article_id`, `icon`, `icon_label`, `affichage`, `marqueur`, `glng`, `glat`, `gzoom`, `catid`, `userid`, `published`, `checked_out`, `metadesc`, `metakey`, `ordering`, `room_id`, `distance`, `ZipRmID`, `rStatus`) VALUES
  </code></pre>
  
  <p>The import settings that I think should work are the following...</p>
  
  <p>FORMAT = CSV</p>
  
  <p>Replace Data Table With File = CHECKED</p>
  
  <p>Columns separated with: ,</p>
  
  <p>Columns enclosed with: '</p>
  
  <p>Columns escaped with: /</p>
  
  <p>Lines terminated with: auto</p>
  
  <p>However, everytime I get this error <strong>"Invalid column count in CSV input on line 1."</strong></p>
  
  <p>I have 39 columns in the existing table &amp; there are 39 columns on the CSV. Every column is seperated with a , and enclosed with a '</p>
  
  <p>What is the issue here &amp; how do I fix this? I have spent all day trying to figure out what the simple solution is but can't figure it out. I know it must be basic but I have tried anything. I give up. HELP!</p>