title: Importing data from excel to teradata error error code 3706 Expected something between ')' and Insert
body: <p>I get an error upon importing an excel in the format:</p>
  
  <pre><code>"hdr1", "hdr2", "hdr3", "hdr4", "hdr5", "hdr6", "hdr7"
  
  "value1","value2","value3","value4","value5","value6","value7"
  </code></pre>
  
  <p>Error statement:</p>
  
  <p>Error executing query for record 1:  [3706] Syntax error: expected something between ')' and the 'INSERT' keyword.</p>
  
  <p>I am using the SQL Teradata Assistant. I tried putting a <code>';'</code>   between the <code>Create Table</code> and the <code>Insert</code>, but that did not help. Teradata expects it to be just one statement.</p>
  
  <p>CREATE TABLE STATEMENT:</p>
  
  <pre><code> CREATE SET TABLE database_name.table_name ,FALLBACK ,
               NO BEFORE JOURNAL,
               NO AFTER JOURNAL,
               CHECKSUM = DEFAULT,
               DEFAULT MERGEBLOCKRATIO
              (
                value1 VARCHAR(1000),
                value2 VARCHAR(1000),
                value3 VARCHAR(1000),
                value4 VARCHAR(1000),
                value5 VARCHAR(1000),
                value6 VARCHAR(1000),
                value7 VARCHAR(1000)
              )
  
          INSERT INTO database_name.table_name  VALUES(?,?,?,?,?,?,?....);
  </code></pre>