IMPORTING BULK DATA

Hi Experts

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
hinamansoorAsked:
Who is Participating?
 
Praveen Kumar ChandrashekatrConnect With a Mentor Database Analysist Senior Commented:
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
try to use the sqlloader as mentioned above to do the bulk loading of the data. if you think for sure that you have hit a problem using sqlloader and that cannot be resolved, then try the alternate option of using utl_file package as that requires some programming effort from you/your team right.
0
 
Mark GeerlingsDatabase AdministratorCommented:
With Oracle Forms6i running in client/server mode (as you told us in another recent question) if you want Forms to load data from either an Excel or *.csv file, that file must be located on the client computer (or on a network drive that is accessible from the client computer).  You normally cannot use a file on the database server computer for this (unless you have a directory there that is shared with the clients).  Also, you normally cannot use SQL*Loader (which is a server-side utility) or UTL_FILE (which is also a server-side program).  

But Oracle Forms supports the FILE_IO utility to read or write from files on the client PC.  You can use this Oracle Forms built-in (FILE_IO) to read the Excel or *.csv file, then use PL\SQL logic in Oracle Forms to process the data from the file.  This is easy with *.csv or *.txt files.  I have never done this with Excel files and Oracle Forms.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.