Home » Developer & Programmer » Forms » How to transfer data from excel sheet to oracle using oracle forms?
How to transfer data from excel sheet to oracle using oracle forms? [message #264341] Mon, 03 September 2007 01:21 Go to next message
gaju_3112
Messages: 28
Registered: September 2007
Location: India
Junior Member

I want to develope an application which will convert the excel sheet data into oracle database (Schema is already created in oracle database) Is it possible to develope such application using oracle forms?Is it possible to create forms that will give good GUI and will serve the purpose?
I am new to forms. Please help me out. if you have any idea regarding this.
Re: How to transfer data from excel sheet to oracle using oracle forms? [message #264344 is a reply to message #264341] Mon, 03 September 2007 01:31 Go to previous messageGo to next message
bbaz
Messages: 138
Registered: April 2007
Senior Member
Searching this Forum you will find several examples and posts on this topic.

As for creating a Basic FORM to read/write to EXCEL, please refer to message #124560 this will give you a good start.

Kindly let us know if this is what you are looking for.

NOTE: if you are planning to load a COMPLETE Excel Sheet and don't want to use partial data from excel, you'd better use SQL LOADER.

Thanks,
Baz
Re: How to transfer data from excel sheet to oracle using oracle forms? [message #264686 is a reply to message #264341] Tue, 04 September 2007 03:23 Go to previous messageGo to next message
gaju_3112
Messages: 28
Registered: September 2007
Location: India
Junior Member

I am totally new to the oracle forms. Can anybody tell me step by step detail procedure of transforming excel data to oracle data using oracle forms? Thanks in advance.
Re: How to transfer data from excel sheet to oracle using oracle forms? [message #264690 is a reply to message #264686] Tue, 04 September 2007 03:42 Go to previous message
bbaz
Messages: 138
Registered: April 2007
Senior Member
HI There,

In my previous Post, I have directed you to and Older Message (#124560) in this FORUM that has the code and some details on connecting and getting data from Excel into Oracle Forms.

Please try to use this code and let us know if it is working.

I am currently using a similar code now and it is working perfectly well.

Regards,
Baz
Previous Topic: configuaring jinitiator on client side under restricted policies
Next Topic: is it possible to write a procedure inside a trigger
Goto Forum:
  


Current Time: Tue Dec 06 08:53:32 CST 2016

Total time taken to generate the page: 0.19722 seconds