title: SQL Loader- data not uploaded to the table. All went to .bad
body: <p>I tried to upload some records into my table <code>ABC</code>. None of the records went through and they all showed up in the <code>.bad</code> log.</p>
  
  <p>I am pretty new to sqlldr. Not quite sure where did I messed up. Let me show you the steps I took.</p>
  
  <p>First, I created an empty table called <code>ABC</code>.</p>
  
  <pre><code> create table abc
      (
        location_id varchar2(10),
        sold_month date,
        item_name varchar2(30),
        company_id varchar2(10),
        qty_sold number(10),
        total_revenue number(14,3),
        promotional_code varchar2(10)
      );
  </code></pre>
  
  <p>Here is my flat file <code>abcflat.dat</code>. The columns correspond to the columns in the table above.</p>
  
  <pre><code>"1000","02/01/1957","Washing Machine","200011","10","10000","ABCDE"
  "1000","05/02/2013","Computer","200012","5","5000","ABCDE"
  "1000","05/01/2013","Bolt","200010","100","500","ABCDE"
  "1000","05/03/2013","Coca Cola","200011","1000","1000","ABCDE"
  </code></pre>
  
  <p>Here is my control file <code>abc.ctl</code></p>
  
  <pre><code>LOAD DATA
  INFILE 'C:\Users\Public\abcflat.dat'
  INTO TABLE ABC
  FIELDS TERMINATED BY "," 
  enclosed by '"'
  (
  Location_ID
  , Sold_month
  , item_name
  , Company_id
  , QTY_Sold
  , Total_revenue
  , Promotional_Code
  )
  </code></pre>
  
  <p>And my last step</p>
  
  <pre><code>sqlldr hr/open@xe control=c:\users\public\abc.ctl
  </code></pre>
  
  <p>It says </p>
  
  <pre><code>Commit point reached - logical record count 3
  Commit point reached - logical record count 4
  </code></pre>
  
  <p>but none of the record showed up on my ABC table.</p>
  
  <p>Thank You</p>