Home » Developer & Programmer » Forms » TEXT_IO read and insert into table (Forms 6i)
TEXT_IO read and insert into table [message #687924] Sat, 22 July 2023 02:33 Go to next message
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.
Re: TEXT_IO read and insert into table [message #687925 is a reply to message #687924] Sat, 22 July 2023 10:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68598
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.

Re: TEXT_IO read and insert into table [message #687970 is a reply to message #687925] Thu, 03 August 2023 14:51 Go to previous messageGo to next message
Littlefoot
Messages: 21802
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.
Re: TEXT_IO read and insert into table [message #687974 is a reply to message #687970] Fri, 04 August 2023 00:54 Go to previous message
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.
Previous Topic: Send Message WhatsAapp
Next Topic: LIST ITEM
Goto Forum:
  


Current Time: Thu Feb 29 22:17:11 CST 2024