Home » Developer & Programmer » Forms » import from excel (oracle 8i dev 6i)
import from excel [message #297290] Thu, 31 January 2008 01:01 Go to next message
Messages: 41
Registered: November 2007
suppose i have the table name "emp" with col's
emp_id and emp_name

and i have an excel file saved on my hard disk on
c:\file1 with same two col's without headers it is only pure data

i want to copy this excel file into my emp table ....using a push butten what is the code i should right inside this trigger ?????

if it is possible i need the minimum code without any validations 4 the fileds and thanks 4 all in advance

Re: import from excel [message #297469 is a reply to message #297290] Thu, 31 January 2008 21:42 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'excel' there are many threads most of which contain pointers to the answers.

Previous Topic: LOV Problem
Next Topic: how to find errors occured during execute_query
Goto Forum:

Current Time: Wed Oct 26 06:54:31 CDT 2016

Total time taken to generate the page: 0.10947 seconds