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

15 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