1 Reply Latest reply on Nov 1, 2017 4:03 PM by Gary Graham-Oracle

    SQL Deveoper(17.3.1.279) import data issues

    e0aa09f5-5490-4c0f-bda7-b90730f1971f

      I try to use SQL Developer to import data from csv file. At the Data Preview phrase, I adjust File Format. When I select or deselect Header,the first line in csv file is always treated as field name.

        • 1. Re: SQL Deveoper(17.3.1.279) import data issues
          Gary Graham-Oracle

          Very strange.  What I see, in 17.3.1 as well as other earlier versions, is that unchecking the Header box changes the wizard page from

          ImportWithColumnHeader.jpg

          to

          ImportWithoutColumnHeader.jpg

          In your case, the COLUMN1, COLUMN2, ... line does not appear as it should at the top of the File Contents section.  My test is on Windows 10.  I see you use a different encoding and no enclosures.  If you vary those options, does it make any difference?

           

          Edit: Also, my file uses the file extension .csv, so Format defaults to csv and no adjustment is necessary. Do you use a different file extension and subsequently need to make an adjustment?

          1 person found this helpful