A question on how oracle can read excel file?

Asked By Timothy Raine 40 points N/A Posted on - 12/13/2012

 

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.

• Status: Open
• Question Views: 801
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Riley weaver

Go To Solution

Answered By Head Jonathon 0 points N/A #184981

A question on how oracle can read excel file?

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.

About Head Jonathon

Questions
8

Answers
115

Best Answers
48

• Vote Up 0 Vote Down

• Posted on - 12/20/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Riley weaver 10 points N/A #184982

A question on how oracle can read excel file?

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.

About Riley weaver

Questions
2

Answers
228

Best Answers
103

• Vote Up 0 Vote Down

• Posted on - 12/20/2012
• Question Category: MS Excel