Home » RDBMS Server » Server Utilities » export data from excel to oracle_10g (oracle10g,toad,excel'07)
export data from excel to oracle_10g [message #445963] Thu, 04 March 2010 22:53 Go to next message
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
Re: export data from excel to oracle_10g [message #445964 is a reply to message #445963] Thu, 04 March 2010 23:00 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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/
Re: export data from excel to oracle_10g [message #446027 is a reply to message #445963] Fri, 05 March 2010 03:31 Go to previous messageGo to next message
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
Re: export data from excel to oracle_10g [message #446041 is a reply to message #445963] Fri, 05 March 2010 05:33 Go to previous messageGo to next message
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
Re: export data from excel to oracle_10g [message #446106 is a reply to message #446027] Fri, 05 March 2010 08:26 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: export data from excel to oracle_10g [message #446498 is a reply to message #446106] Mon, 08 March 2010 22:22 Go to previous messageGo to next message
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
Re: export data from excel to oracle_10g [message #446500 is a reply to message #446498] Mon, 08 March 2010 22:30 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=excel+to+oracle+data+upload
Previous Topic: SQL Loader BFILE - Column Pointer Value is: FSSLPB//I (NoExist)
Next Topic: Import only sequences using data pump
Goto Forum:
  


Current Time: Fri Dec 02 14:32:05 CST 2016

Total time taken to generate the page: 0.13122 seconds