OraFAQ Forum: Forms » import data from excel

Home » Developer & Programmer » Forms » import data from excel (form builder 6i)

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

import data from excel [message #392981]

Thu, 19 March 2009 21:19

fadhzone
Messages: 61
Registered: April 2008

Member

hi all,
i have an 6 columns excel file. This file contains the data only.
There is no title for the column.

I have an example of script to import the data from excel into
form but the excel file has title for the column, but my excel file don't have the title.

My question is how to import the data. I just get the idea by checking the column,column1 column2...column6 but i don't know how to write the script.

I already searched all the answer from the forum but i can't find the suitable answer.

Thanks.

Report message to a moderator

Re: import data from excel [message #392986 is a reply to message #392981]

Thu, 19 March 2009 22:12

xpact83
Messages: 225
Registered: October 2008
Location: philippines

Senior Member

/*
** Open a file and read the first line
** into linebuf.
*/
declare
in_file Text_IO.File_Type;
linebuf VARCHAR2(80);
begin
in_file := Text_IO.Fopen('salary.txt', 'r');
Text_IO.Get_Line(in_file,linebuf);
end;

try this...

but this is for a text file

Report message to a moderator