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
akramrabaya
Messages: 41
Registered: November 2007
Member
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



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

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


Current Time: Sat Feb 15 02:22:53 CST 2025