Solved

IMPORTING BULK DATA

Posted on 2013-12-23
3
342 Views
Last Modified: 2014-01-08
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
0
Comment
Question by:hinamansoor
3 Comments
 
LVL 12

Accepted Solution

by:
praveencpk earned 500 total points
ID: 39737889
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 39739739
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
 
LVL 34

Expert Comment

by:Mark Geerlings
ID: 39742726
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now