OraFAQ Forum: Forms » TEXT_IO read and insert into table

Home » Developer & Programmer » Forms » TEXT_IO read and insert into table (Forms 6i)

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

TEXT_IO read and insert into table [message #687924]

Sat, 22 July 2023 02:33

chat2raj.s
Messages: 161
Registered: October 2010
Location: Chennai, India

Senior Member

I need to open and read a TXT file with comma separated for multiple columns and to insert into a table.
Any examples on this will help.

Report message to a moderator

Re: TEXT_IO read and insert into table [message #687925 is a reply to message #687924]

Sat, 22 July 2023 10:14

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I'm pretty sure you will get some using the "Search" link above or Google.

Report message to a moderator

Re: TEXT_IO read and insert into table [message #687970 is a reply to message #687925]

Thu, 03 August 2023 14:51

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

Senior Member
Account Moderator

Forms 6i is a client-server architecture. As you have to put all forms onto each user's computer, one option is to install SQL*Loader onto each PC as well. Check Client software for more info (i.e. you don't have to install the whole database as Client lets you choose which utilities you'll install).

Then create a control file (which instructs the utility how to load data; you'd copy it to user's PC) and call it from a form using the HOST built-in procedure.

Report message to a moderator

Re: TEXT_IO read and insert into table [message #687974 is a reply to message #687970]

Fri, 04 August 2023 00:54

chat2raj.s
Messages: 161
Registered: October 2010
Location: Chennai, India

Senior Member

Thank you. As of now i used .xls format to fix my requirement.
I will try the option suggested too.

Report message to a moderator

Previous Topic:	Send Message WhatsAapp
Next Topic:	LIST ITEM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 15:39:33 CDT 2024