A question on how oracle can read excel file?

Asked By 40 points N/A Posted on -
qa-featured

 

Hello techyv,

A question on how oracle can read excel file? Does oracle database read excel file data such as .xls file format? What if we need to import some excel file in a specific database is there a way that we can open or read the file using oracle database? Just for example in my website, if I upload and download excel file formats. I need your advice.

 

Expecting some help from you guys. Thank you.

SHARE
Best Answer by Riley weaver
Answered By 0 points N/A #184981

A question on how oracle can read excel file?

qa-featured

There are many ways to load excel to oracle. I have listed down one option.

1. Save the Excel spreadsheet as a .csv file.
2. Create a table within the Oracle database to hold the data.
3. Find the local server and copy that csv file to it.
4. Create a control file.
5. Start SQL loader from the command line and you should see the rows inserted and committed as they load.

Please see the link https://resources.oreilly.com/examples/9781565929487/ for details related to SQL loader.

Thank you.

Best Answer
Best Answer
Answered By 10 points N/A #184982

A question on how oracle can read excel file?

qa-featured

Hi there,

Microsoft Excel is designed for so many reasons. Keeping data into a spreadsheet manner is the main goal of Microsoft Excel. It is compatible with almost every kind of database system. The fact is only .CSV files are usually suitable for all kind of database systems. Now you can import any .CSV file in oracle database by following few simple steps.

1.       Go to graphical representation mode and you will find an option Import.

2.       Click on that

3.       Select the *.CSV file to the database.

4.       It will ask for few configurations.

5.       Fill the fields with proper values

.CSV files will appear as a database file in there.

Thank you,

Riley Weaver.

Related Questions