OraFAQ Forum: Client Tools » How to import an excel file to database table using TOAD

Home » Other » Client Tools » How to import an excel file to database table using TOAD (Windows XP SP3)

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

How to import an excel file to database table using TOAD [message #489435]

Sun, 16 January 2011 09:45

oraQ
Messages: 57
Registered: January 2011

Member

I am new to Toad and want to load data from an excel file to a database table in Oracle. Can anyone suggest me the way how to do it? I am using Oracle 11 and the excel file has 3 columns as compared to 5 columns in the destination table. I want to generate sequential nos also for the table.

Thanks in advance.
OraQ

[Updated on: Sun, 16 January 2011 10:13] by Moderator

Report message to a moderator

Re: How to import an excel file to database table using TOAD [message #489438 is a reply to message #489435]

Sun, 16 January 2011 10:14

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

Senior Member
Account Moderator

Do NOT use code tags to post your question.
Use code tags for CODE.

Regards
Michel

Report message to a moderator

Re: How to import an excel file to database table using TOAD [message #489441 is a reply to message #489438]

Sun, 16 January 2011 10:22

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

Senior Member
Account Moderator

And do NOT multipost your question. Once is sufficient, just choose the correct forum.

Regards
Michel

Report message to a moderator

Re: How to import an excel file to database table using TOAD [message #489442 is a reply to message #489438]

Sun, 16 January 2011 10:25

oraQ
Messages: 57
Registered: January 2011

Member

Thanks for your suggestion. Will you suggest the way to transfer the data?
Thanks again.
OraQ

Report message to a moderator

Re: How to import an excel file to database table using TOAD [message #489443 is a reply to message #489442]

Sun, 16 January 2011 10:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Automate loading of data from Excel spreadsheets into database
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:243814703172

Install Oracle client software on Windows system running Excel.
Then connect Excel to Oracle DB via ODBC protocol & issue SQL directly from Excel against the DB

Report message to a moderator

Re: How to import an excel file to database table using TOAD [message #489452 is a reply to message #489443]

Sun, 16 January 2011 12:28

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

Senior Member
Account Moderator

From my point of view: TOAD is a wrong tool for what you are doing. The fact that it offers loading values from Excel files doesn't mean that you can't use other options (SQL*Loader being the most obvious and reliable).

As of your question: use the wizard! Read all it says and do as it tells you. As far as I can tell, it will load those values, but I'm not sure it is capable of creating sequential values (and don't have TOAD here to test it).

Report message to a moderator