title: Loading a CSV into Bigquery using bq
body: <p>I'm trying to do something I feel like is pretty simple but can't seem to get it to work.  I created a table in Bigquery and am now trying to use the bq tool to import data in to it.  The file I'm trying to import in to the table is a CSV file that uses quotes on columns that have data that could have commas in them.  </p>
  
  <p><strong>Table:</strong></p>
  
  <p>-ColA string 
  -ColB string
  -ColC string
  -ColD integer</p>
  
  <p><strong>File:</strong></p>
  
  <p>"ColA data","ColB data","ColC data", ColD data </p>
  
  <p><strong>Command</strong></p>
  
  <p>bq load --quote "" --format=csv dataset.TableName c:\path\filename.csv ColA:string,ColB:string,ColC:string,ColD:integer</p>
  
  <p>The error I'm getting is:
  "-Error while reading data, error message:  Too many values in row starting at position: 164"</p>
  
  <p>The curious thing is that position 164 happens to be the end of line 1 in the file I'm trying to import. If I delete all of the data it loads that first row, but if I put the other rows back in then it fails out again.  Is there a option to set that the file is row terminator with CR/LF?  I would think that is just the default because its a standard CSV but just a thought.  </p>