Can I port Access Data To Oracle Table through D2k [message #86010] |
Fri, 20 August 2004 23:34 |
palas
Messages: 9 Registered: March 2004
|
Junior Member |
|
|
Dear All,
I want to port the attendence data in oracle table . But the attendence data is in Access database. Is it possible to port the data to oracle table via D2k. I am using Forms 4.5 version.
If not possible (any other way) how can I do this?
Thanks in advance
Regards
Palas
|
|
|
Re: Can I port Access Data To Oracle Table through D2k [message #86046 is a reply to message #86010] |
Tue, 24 August 2004 23:00 |
Himanshu
Messages: 457 Registered: December 2001
|
Senior Member |
|
|
Hi,
Make use of OCA(open Client Adapter) to connect to Access Database from Forms,Fetch the Data into your Form and then move it to your Oracle DB.
Though the simplest way would be export data from Access tables into TXT files and then load it into Oracle Tables using SQL*Loader.
HTH
Regards
Himanshu
|
|
|
|
|