OraFAQ Forum: Server Utilities » export data from excel to oracle

Home » RDBMS Server » Server Utilities » export data from excel to oracle_10g (oracle10g,toad,excel'07)

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

export data from excel to oracle_10g [message #445963]

Thu, 04 March 2010 22:53

kushal.bangabash
Messages: 3
Registered: March 2010
Location: jamshedpur

Junior Member

dear Sir/ma'm,
i need to export master data in excel sheets to our database and we use toad too.can you pls suggest me how i can export the data with the use of macros in excel.Even if u can suggest me how i can export data from excel to oracle,it will be greatly appeciated.
thank you for your attention.

Regards,
Kushal
ph +91 90317 26630

Report message to a moderator

Re: export data from excel to oracle_10g [message #445964 is a reply to message #445963]

Thu, 04 March 2010 23:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>can you pls suggest me how i can export the data with the use of macros in excel.

Exactly what is supposed to be done with the macros?

>Even if u can suggest me how i can export data from excel to oracle,it will be greatly appeciated.

Excel can create an OBDC connection directly into Oracle.
The details can be found elsewhere (not this Oracle forum) since Oracle treats all client connections the same way.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: export data from excel to oracle_10g [message #446027 is a reply to message #445963]

Fri, 05 March 2010 03:31

kushal.bangabash
Messages: 3
Registered: March 2010
Location: jamshedpur

Junior Member

i have to create macros which will enable me to update and/or insert data in the oracle data base.Importing the data from the database is easy but am finding it difficult to export the data to the database.The master data is in excel files and i have to create buttons which will be assigned to these update or insert macros.Thus,by clicking the button,my data cann be directly exported to the database.
I am new to this forum and am finding it difficult to find the appropiate forum to post my queries into.I would be very obliged if anyone can help me out with my issue.

Regards,
kushal

Report message to a moderator

Re: export data from excel to oracle_10g [message #446041 is a reply to message #445963]

Fri, 05 March 2010 05:33

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Hi,
I am not able to understand your requirement clearly.
But external tables might help you for this requirement that can directly pick the data from excel/csv files and import into the Oracle tables.

Regards
Lalit

Report message to a moderator

Re: export data from excel to oracle_10g [message #446106 is a reply to message #446027]

Fri, 05 March 2010 08:26

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

The master data is in excel files and i have to create buttons which will be assigned to these update or insert macros.Thus,by clicking the button,my data cann be directly exported to the database.

Sorry to say not able to understand. You mean to say; Need to import data's from excel sheet to oracle??

-Babu

Report message to a moderator

Re: export data from excel to oracle_10g [message #446498 is a reply to message #446106]

Mon, 08 March 2010 22:22

kushal.bangabash
Messages: 3
Registered: March 2010
Location: jamshedpur

Junior Member

The data is in excel sheets and i have to send this data in our oracle database.If my requirements are clear to you,then i would be very obliged for your views regarding my query.
Regards,
Kushal

Report message to a moderator

Re: export data from excel to oracle_10g [message #446500 is a reply to message #446498]

Mon, 08 March 2010 22:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.lmgtfy.com/?q=excel+to+oracle+data+upload

Report message to a moderator

Previous Topic:	SQL Loader BFILE - Column Pointer Value is: FSSLPB//I (NoExist)
Next Topic:	Import only sequences using data pump

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 17:00:40 CDT 2024