OraFAQ Forum: Forms » Excel Upload in Forms 12c

Home » Developer & Programmer » Forms » Excel Upload in Forms 12c (Forms 12c 12.2.1.2)

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

Excel Upload in Forms 12c [message #668171]

Sat, 10 February 2018 22:30

orafaq321
Messages: 8
Registered: February 2018

Junior Member

Hi All,

I am new to Forms 12c, we are upgrding forms 6i to 12c.

In 12c OLE2 is not working to upload excel. Can any please help me...

Thanks in advance...

Report message to a moderator

Re: Excel Upload in Forms 12c [message #668172 is a reply to message #668171]

Sat, 10 February 2018 22:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

orafaq321 wrote on Sat, 10 February 2018 20:30

Hi All,

I am new to Forms 12c, we are upgrding forms 6i to 12c.

In 12c OLE2 is not working to upload excel. Can any please help me...

Thanks in advance...

I am sure that "not working" is 100% correct, but it is also 100% devoid of any useful detail to discern what is actually wrong.

We can't see what you do.
We can't see what you see.
We don't know what is wrong.

You have a mystery & we have no clues.

The one fact that I know for sure Oracle does not speak "Excel".
Oracle can produce text data in various formats, CSV, XML, etc., that Excel an import

Report message to a moderator

Re: Excel Upload in Forms 12c [message #668174 is a reply to message #668172]

Sun, 11 February 2018 08:04

orafaq321
Messages: 8
Registered: February 2018

Junior Member

Thanks for the reply BlackSwan...

Let me explain my probelm...

We are upgrading forms 6i to 12c. In 6i version, there is a form which will upload excel(.xls) data into oracle table by using OLE2.

We are able to compile the 6i form in 12c without any compilation error, but OLE2 is not working in 12c version.

Is there any alternative option which can be used in place of OLE2 in 12c?

Please help me...

Thanks in advance.

Report message to a moderator

Re: Excel Upload in Forms 12c [message #668177 is a reply to message #668174]

Sun, 11 February 2018 09:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Why do you think this is an Oracle problem & not a Microsoft problem?

What makes you think that OLE2 is compatible with current Windows version?

Again you state it is "not working"; which is 100% devoid of any useful detail.

My car is not working.
Tell me how to make my car go.

Report message to a moderator

Re: Excel Upload in Forms 12c [message #668178 is a reply to message #668177]

Sun, 11 February 2018 09:54

orafaq321
Messages: 8
Registered: February 2018

Junior Member

Hi...

Not working means, not able to uplaod excel data into oracle table,
at the same time it is not giving any error message.

As per my search in google, OLE2 will not work in Forms 12c.

My requirement is to upload the excel data into oracle table using Forms 12c.

So I need replace existing OLE2 package.

I am not sure whether forms 12c provided any new facility to upload excel into oracle tables.

Please help...

Report message to a moderator

Re: Excel Upload in Forms 12c [message #668181 is a reply to message #668178]

Sun, 11 February 2018 12:10

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

Senior Member
Account Moderator

I don't know about Forms 12 (don't have it), but - would Webutil help? Have a look at WebUtil: How to Read an Excel file into an Oracle Form.

Report message to a moderator

Re: Excel Upload in Forms 12c [message #668532 is a reply to message #668181]

Wed, 28 February 2018 09:31

orafaq321
Messages: 8
Registered: February 2018

Junior Member

Thanks for the reply...
I am using the code given in above link. But at this point application is hanging.

application := Client_OLE2.create_obj('Excel.Application');

Installing XL s/w in appliation/DB server is mandatory? or only client system is sufficient?

Report message to a moderator

Re: Excel Upload in Forms 12c [message #668545 is a reply to message #668532]

Wed, 28 February 2018 13:22

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

client_ole sounds to me like webutil is required.

Report message to a moderator

Re: Excel Upload in Forms 12c [message #668547 is a reply to message #668545]

Wed, 28 February 2018 21:10

orafaq321
Messages: 8
Registered: February 2018

Junior Member

webutil already attached. No compilation errors. During program execution it is hanging at this place

application := Client_OLE2.create_obj('Excel.Application');

Report message to a moderator