?
Solved

Need a Procedure to Import Excel to Oracle 11g in SQL Navigator ?

Posted on 2014-11-03
5
Medium Priority
?
1,497 Views
Last Modified: 2014-12-07
I am using SQL Navigator for Oracle 11g.

I am looking for Import Procedure to Import an Excel file to SQL Navigator.
0
Comment
Question by:chokka
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 40420935
Why SQL Navigator? perhaps you are using the incorrect utility,
Did you try SQL Developer?
:p
0
 
LVL 38

Accepted Solution

by:
Gerwin Jansen, EE MVE earned 2000 total points
ID: 40421007
SQL Developer is from Oracle, it's free, you get it here: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

In SQL Developer, open a connection, right click 'Tables' under the open connection and choose 'Import Data', point to your Excel file and follow the Wizard to import your data.
0
 

Author Comment

by:chokka
ID: 40423869
I think, i found the solution.

I export from excel to access db and from access db  i connect to oracle 11g through dsn connection.
0
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40423960
But that is not what you asked right?  Then we could have suggested sql loader for example.
0
 

Author Closing Comment

by:chokka
ID: 40485959
Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question