OraFAQ Forum: Forms » Loading data from excel into a table

Home » Developer & Programmer » Forms » Loading data from excel into a table

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

Loading data from excel into a table [message #82872]

Thu, 10 July 2003 15:33

sandu
Messages: 51
Registered: June 2003

Member

Scenario:-

Form layout:-

Browse :- ________
start (button)
end (button)

Excel layout:-
emp.xls

Empno name
100 xyz
200 pqr

Table layout:-

Create table emp(
Empno varchar2(20),
name varchar2(40))

Question:-

I would like the user to browse a file from
his local machine named emp.xls. Once the user
selects the file he should be able to hit the start
button to load data into an oracle table 'emp'.
Is this doable using forms 4.5. If so how?.
Thx.

Report message to a moderator

Re: Loading data from excel into a table [message #82884 is a reply to message #82872]

Mon, 14 July 2003 05:06

sujit
Messages: 94
Registered: April 2002

Member

hi,
You can rather ask for csv format. upon giving in FLAT TEXT format you can use the sqlldr utily to upload data into your table.

Sujit

Report message to a moderator

Re: Loading data from excel into a table [message #82887 is a reply to message #82884]

Mon, 14 July 2003 13:19

sandu
Messages: 51
Registered: June 2003

Member

Sujit,

Sqlldr with .csv file would definitely work.Done that
before. Seems like no way to read the hard drive from
a form like VB which has specific DLL's to do it.

Sandy.

Report message to a moderator