2 Replies Latest reply: Aug 21, 2013 3:10 PM by 996454 RSS

    Importing data into an existing table from excel problem

    996454

      Hopefully I am posting this in the right place..

       

      I am having trouble importing data from Excel into an oracle table using the 'import data' wizard in SQL developer.

       

      The problem is that the I want to import data into a table which all ready has data and I want the new data to be imported into the first row of the table not in a new row at the end of the table.

       

      This is probably best shown by example:

       

      create table todelete (
           site_no varchar2(2),
           data1 number,
           qa number);

      insert into todelete values ('w1',1,null);
      insert into todelete values ('w1',2, null);
      insert into todelete values ('w1',3,null);

       

      Now I want to import the following data from excel into the QA column starting at w1:

      SITE_NOQA
      w14
      w24
      w34

       

      However, when I import the QA column it goes into a new row:

       

      SITE_NODATA1QA
      w11NULL
      w22NULL
      w33NULL
      NULLNULL4
      NULLNULL4
      NULLNULL4