Home » Infrastructure » Windows » Create table from EXCEL Table (Oracle 9i 9.2.0.1)
Create table from EXCEL Table [message #351591] Wed, 01 October 2008 11:57 Go to next message
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.
Re: Create table from EXCEL Table [message #351592 is a reply to message #351591] Wed, 01 October 2008 11:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are many topics here on the subject here which ones did you read and try?

Regards
Michel
Re: Create table from EXCEL Table [message #351601 is a reply to message #351592] Wed, 01 October 2008 12:27 Go to previous messageGo to next message
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.
Re: Create table from EXCEL Table [message #351607 is a reply to message #351601] Wed, 01 October 2008 12:42 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, there are and they are explained HERE.

Regards
Michel
Previous Topic: WinXP vs Win2003 Server
Next Topic: ODBC not reading TNS_ADMIN
Goto Forum:
  


Current Time: Thu Mar 28 16:52:08 CDT 2024