OraFAQ Forum: Windows » Create table from EXCEL Table

Home » Infrastructure » Windows » Create table from EXCEL Table (Oracle 9i 9.2.0.1)

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

Create table from EXCEL Table [message #351591]

Wed, 01 October 2008 11:57

Bonita
Messages: 32
Registered: June 2008

Member

Knowing this is quite simple question, google a lots and still didn't find simple way to build table from EXCEL source using current utility tool.

Does someone help me out of how to create a table from excel data source using Oracle 9i facility ? THANK YOU.

For instance, I have an excel file and located at D:\Profiles\Bonita\My Documents\Sample.xls, how do I create a table in Oracle 9i ? And if excel source updates on a daily basis, what settings I need to build ?

Oracle 9i is installed in personal machine at standalone model.

Because I'm new to Oracle, please describe step by step.

Thank you very much for your time and reply.

Report message to a moderator

Re: Create table from EXCEL Table [message #351592 is a reply to message #351591]

Wed, 01 October 2008 11:59

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There are many topics here on the subject here which ones did you read and try?

Regards
Michel

Report message to a moderator

Re: Create table from EXCEL Table [message #351601 is a reply to message #351592]

Wed, 01 October 2008 12:27

Bonita
Messages: 32
Registered: June 2008

Member

Tried QuickLoad1 ( http://sourceforge.net/projects/quickload ), too many parameters need to be set up before using ( from Readme.txt ). I'm wondering if Oracle has easy-to-use tool, such as SQLLoader, or someelse for one-click-and-go.

Thank you.

Report message to a moderator

Re: Create table from EXCEL Table [message #351607 is a reply to message #351601]

Wed, 01 October 2008 12:42

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, there are and they are explained HERE.

Regards
Michel

Report message to a moderator

Previous Topic:	WinXP vs Win2003 Server
Next Topic:	ODBC not reading TNS_ADMIN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 19:10:47 CST 2024