Home » Developer & Programmer » Forms » how do I migrate 5000 records from excel to Apps
how do I migrate 5000 records from excel to Apps [message #79350] Wed, 29 May 2002 09:59 Go to next message
Micky
Messages: 18
Registered: January 2002
Junior Member
I'm trying to migrate 5000 employee records from a legacy system to Oracle payroll. i've tried using data loader but it falls down when crossing difficult fields. If I use SQL loader how do I get data out of the tables created by the control file into Apps screens.
Any ideas
Re: how do I migrate 5000 records from excel to Apps [message #79369 is a reply to message #79350] Sat, 01 June 2002 04:22 Go to previous messageGo to next message
Hemant Pahade
Messages: 3
Registered: April 2002
Junior Member
Create excel as a database and then connect by ODBC to forms
in this way u fetch all record from excel to Forms then
write insert statement to oracle table for insertion
Re: how do I migrate 5000 records from excel to Apps [message #79384 is a reply to message #79369] Wed, 05 June 2002 04:21 Go to previous message
mani
Messages: 105
Registered: September 1999
Senior Member
HAI...
YOU CAN USE UTL_FILE UTILITY TO DO THE SAME THING....
MANI
Previous Topic: Sorting records after a Fetch into a block!!!! URGENT
Next Topic: clear fields in a tabular form
Goto Forum:
  


Current Time: Thu May 23 04:27:43 CDT 2024