OraFAQ Forum: Forms » How to transfer data from excel sheet to oracle using oracle forms?

Home » Developer & Programmer » Forms » How to transfer data from excel sheet to oracle using oracle forms?

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

How to transfer data from excel sheet to oracle using oracle forms? [message #264341]

Mon, 03 September 2007 01:21

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.

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 03 02:43:22 CDT 2025