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
  4. The term Agile software development was coined in the year 2001, subsequently to the formulation of the Agile Manifesto. DB Designer

    ReplyDelete
  5. Python Development Services providers across the world for developing a wide range of software applications. It allows developers to express concept with less and readable code. It enable the developers to integrate Python with varied other well-known programming languages and tools flawlessly. unindent does not match any outer indentation level python

    ReplyDelete