OraFAQ Forum: Forms » IMPORTING BULK DATA

Home » Developer & Programmer » Forms » IMPORTING BULK DATA (FORM 6i ON WINDOW 7 32 BITS)

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

IMPORTING BULK DATA [message #603270]

Thu, 12 December 2013 17:28

kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania

Senior Member

Hi Friends

I have a problem

I want to have a button so that when it is pressed it imports student_no,arriving_time,leaving_time and supervisor_name from the excel/CSV file.

Please help, how do I go about?

Thank you in advance

Report message to a moderator

Re: IMPORTING BULK DATA [message #603271 is a reply to message #603270]

Thu, 12 December 2013 17:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

client/server or webforms?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: IMPORTING BULK DATA [message #603289 is a reply to message #603271]

Fri, 13 December 2013 00:24

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If it is a true CSV file, I'd go with SQL*Loader: create its control file; create a DOS batch file which would call SQLLDR executable and use previously created control file; call that batch script from a form using HOST built-in procedure.

Report message to a moderator

Re: IMPORTING BULK DATA [message #604005 is a reply to message #603289]

Sun, 22 December 2013 11:41

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

Use Keeptool Software to import any kind of data.please see the attached picture. /forum/fa/11478/0/

Please use this link to download.
http://www.keeptool.com/en/downloadothers.php

Attachment: 545.JPG
(Size: 115.89KB, Downloaded 1872 times)

Report message to a moderator

Re: IMPORTING BULK DATA [message #604166 is a reply to message #604005]

Wed, 25 December 2013 07:31

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

have you solved your problem

Report message to a moderator

Re: IMPORTING BULK DATA [message #605010 is a reply to message #604166]

Mon, 06 January 2014 19:17

kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania

Senior Member

Hi

Sorry for late reply.I have not solved my problem.

I just want some code under the button only to be pressed and upload data .

thank you.

Report message to a moderator

Re: IMPORTING BULK DATA [message #605011 is a reply to message #603289]

Mon, 06 January 2014 19:22

kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania

Senior Member

Hi Little foot,

How do I go about that?

Report message to a moderator

Re: IMPORTING BULK DATA [message #605012 is a reply to message #605011]

Mon, 06 January 2014 22:15

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

send me your dmp or excel files so i can move data..

[Updated on: Mon, 06 January 2014 22:15]

Report message to a moderator

Re: IMPORTING BULK DATA [message #605045 is a reply to message #605011]

Tue, 07 January 2014 03:16

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

milikiel wrote on Tue, 07 January 2014 01:22

Hi Little foot,

How do I go about that?

LF gave a set of instructions, what exactly do you not understand?

Report message to a moderator

Re: IMPORTING BULK DATA [message #605046 is a reply to message #605012]

Tue, 07 January 2014 03:16

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

shahzad-ul-hasan wrote on Tue, 07 January 2014 04:15

send me your dmp or excel files so i can move data..

What on earth are you going to do with someone else's data?

Report message to a moderator

Re: IMPORTING BULK DATA [message #605052 is a reply to message #605046]

Tue, 07 January 2014 03:50

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

it can be accomplised by writing and PLSQL program using UTL_FILE package or you can use SQL*Loader.
as Sir@littlefoot already sugggested.

   load data
        infile 'c:\data\mydata.csv'
        into table emp
  fields terminated by "," optionally enclosed by '"'          
   ( empno, empname, sal, deptno )

here are some of the examples

https://community.oracle.com/thread/2379737?tstart=0

http://stackoverflow.com/questions/4242503/loading-a-csv-file-into-oracle-table

http://stackoverflow.com/questions/10980779/import-csv-file-into-table-using-sql-loader-but-large-no-of-columns

Regard
Mughal

[Updated on: Tue, 07 January 2014 03:52]

Report message to a moderator

Re: IMPORTING BULK DATA [message #629028 is a reply to message #605052]

Tue, 02 December 2014 07:36

kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania

Senior Member

Thank you all.

Report message to a moderator

Previous Topic:	Issue with excel Import. Unable to import excel number field into varchar2 column
Next Topic:	how to manually lock/unlock record in forms 6i with where clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 18:21:14 CDT 2025