Importing data from a text file into Forms - Very urgent!

[statcan]

Hi

I have an application that is built using Forms Builder. The data is sent to our team in a text format and needs to be loaded/imported into the tables in Forms. How can this be done? I have searched for an import facility or a load facility but found none. Can Reports be used for this and then populated from Reports...

Please help!

 

[sem]

Is loading in Forms a mandatory requirement? I mean, isn't it easier to load it by sql*loader? Though, even from forms you may use text_io package to read this file data, parse it and either populate an appropriate block or execute sql statements directly from some Forms trigger.

Regards, Dima

 

[statcan]

Sql*Loader will be an easier path, you are right. But our clients do not have it installed. I will try the text-io and get back..

thanx for a quick reply