OraFAQ Forum: Server Utilities » What is the best way to load Excel sheet data in to Oracle database Tables?

Home » RDBMS Server » Server Utilities » What is the best way to load Excel sheet data in to Oracle database Tables?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What is the best way to load Excel sheet data in to Oracle database Tables? [message #265146]

Wed, 05 September 2007 09:44

vshalpatel
Messages: 5
Registered: September 2007

Junior Member

i want to load Excel sheet data in to Oracle database Tables.
can i get this done by SQL*LOADER? as much as i know we can load data from .CSV and .TXT files to Oracle databae tables using SQL*LOADER. i am not sure if i can acheive the same if my source is Excel sheet.

Could someone suggext me how to get this done?

Thanks
Vishal

Report message to a moderator

Re: What is the best way to load Excel sheet data in to Oracle database Tables? [message #265149 is a reply to message #265146]

Wed, 05 September 2007 09:53

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:243814703172

Report message to a moderator

Re: What is the best way to load Excel sheet data in to Oracle database Tables? [message #265191 is a reply to message #265146]

Wed, 05 September 2007 12:59

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I didn't follow a link to AskTom, so I may be saying what you've already seen. But OK, here it is: Excel allows you to save a file as CSV file. Once you do that, use it as a source for SQL*Loader or even as an external table (if your database supports this feature).

Report message to a moderator

Previous Topic:	SQL*LOADER ERROR 500 Unable to open File , File not found
Next Topic:	Backup & Import Database \| Problems with user-rules

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 10:04:44 CST 2024