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

20 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