Home » Developer & Programmer » Forms » import data from excel (form builder 6i)
import data from excel [message #392981] Thu, 19 March 2009 21:19 Go to next message
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.
Re: import data from excel [message #392986 is a reply to message #392981] Thu, 19 March 2009 22:12 Go to previous messageGo to next message
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
Re: import data from excel [message #392988 is a reply to message #392986] Thu, 19 March 2009 22:23 Go to previous messageGo to next message
fadhzone
Messages: 61
Registered: April 2008
Member
xpact83,
Thanks for the answer.I tried using *.csv file.it works.
But,the user save *.xls file.

I tried using *.xls file but didn't work.
Re: import data from excel [message #394925 is a reply to message #392988] Mon, 30 March 2009 18:42 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: form not run
Next Topic: Send email to different id's
Goto Forum:
  


Current Time: Sun Dec 04 12:33:49 CST 2016

Total time taken to generate the page: 0.08382 seconds