top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to access excel sheet data in Oracle database?

+2 votes
417 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 LinkedIn 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
...