• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:


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
1 Solution
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
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.
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.
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now