Home » Developer & Programmer » Forms » IMPORTING BULK DATA (FORM 6i ON WINDOW 7 32 BITS)
IMPORTING BULK DATA [message #603270] Thu, 12 December 2013 17:28 Go to next message
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
Re: IMPORTING BULK DATA [message #603271 is a reply to message #603270] Thu, 12 December 2013 17:35 Go to previous messageGo to next message
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/
Re: IMPORTING BULK DATA [message #603289 is a reply to message #603271] Fri, 13 December 2013 00:24 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: IMPORTING BULK DATA [message #604005 is a reply to message #603289] Sun, 22 December 2013 11:41 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 615
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 1498 times)
Re: IMPORTING BULK DATA [message #604166 is a reply to message #604005] Wed, 25 December 2013 07:31 Go to previous messageGo to next message
mughals_king
Messages: 392
Registered: January 2012
Location: pakistan
Senior Member
have you solved your problem
Re: IMPORTING BULK DATA [message #605010 is a reply to message #604166] Mon, 06 January 2014 19:17 Go to previous messageGo to next message
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.
Re: IMPORTING BULK DATA [message #605011 is a reply to message #603289] Mon, 06 January 2014 19:22 Go to previous messageGo to next message
kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania
Senior Member
Hi Little foot,

How do I go about that?
Re: IMPORTING BULK DATA [message #605012 is a reply to message #605011] Mon, 06 January 2014 22:15 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 615
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 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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?
Re: IMPORTING BULK DATA [message #605046 is a reply to message #605012] Tue, 07 January 2014 03:16 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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?
Re: IMPORTING BULK DATA [message #605052 is a reply to message #605046] Tue, 07 January 2014 03:50 Go to previous messageGo to next message
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 Go to previous message
kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania
Senior Member
Thank you all.
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:
  


Current Time: Fri Mar 29 02:21:07 CDT 2024