top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How to access excel sheet data in Oracle database?

+2 votes
90 views

I have an excel sheet to be upload on oracle and so that data can be access with SQL commands.
Please suggest some opinions...

posted May 13, 2014 by Rakesh Singh

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

First save the excel sheet data into CSV then you can import CSV data oracle using Oracle Application Express, which comes free with Oracle, includes a "Load Spreadsheet Data" utility under:

Utilities > Data Load/Unload > Load > Load Spreadsheet Data
answer May 13, 2014 by Salil Agrawal
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...