?
Solved

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

Posted on 2014-11-03
5
Medium Priority
?
1,635 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
  • 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

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

578 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