Wednesday, June 20, 2012

SQL Developer import from Excel or CSV

Goal: how to import EXCEL,CSV data to Oracle or Mysql DB.


  • install SQL DEVELOPER on Windows or Linux. In this example SQL DEV 3.1.07 (optional).
  • installation on windows download sqldeveloper-3.1.07.42.zip unzip use it
  • installation on linux RHEL 5, download JDK and SQL DEVELOPER
with root:



and


execute with oracle or root:
[oracle@lv-test ~]$ sqldeveloper
Oracle SQL Developer
 Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.




  • Check what NLS is on DB(optional).
  • Check NLS settings in SQL DEV tools->preferences-NLS (optional).

  • Create a connection to the database in SQL Developer with proper NLS settings
  • Create a table as a destination for the xls data
Example:
create table TEST1 (column1 VARCHAR(100),column2 VARCHAR(100));  

  • right click on the table select 'import data' 



  • use xls or csv data format
  • select file
  • use the wizzard 

 done

23 comments:

  1. I just tried this with a mysql db, but I only have the option open, export and copy to oracle in the right click menu. What could be missing, some kind of filter/extension?

    ReplyDelete
  2. If you have a mobile app development company and you need a dedicated android or iPhone app developer, then dedicated developers can help. Since these areas need expertise in the field, it is important to hire experts to get your task completed.Edknt Media

    ReplyDelete
  3. I'll review this blog as An and it demonstrates how much exertion has been put into this.
    como importar dos eua

    ReplyDelete
  4. The term Agile software development was coined in the year 2001, subsequently to the formulation of the Agile Manifesto. DB Designer

    ReplyDelete
  5. Flutter Programming is one of the most popular in the cross platforms industry. We build excellent flutter mobile app and also learn how to overcome performance issues. Offshore Flutter Development Service is the best choice for all startups to discuss and get their project quotation. We also enable many startups to do Proof of concept and help them to learn about business decisions.

    ReplyDelete
  6. Are you a web developer? Then give a helping hand to your young ones. Let's grow the world knowledge. Head over to Thinkle Developers and help a seeker please.

    ReplyDelete