Click to See Complete Forum and Search --> : Converting Database


Swapnil
May 17th, 2004, 12:06 PM
Is there a tool or s/w to convert a MS Access database into an Oracle one??

TheCPUWizard
May 17th, 2004, 12:43 PM
Not directly, but if you load the ODBC drivers for Oracle, then it is fairly trivial to write a script to perform the operations.

Swapnil
May 17th, 2004, 01:23 PM
Could u plz explain it bit more...

TheCPUWizard
May 17th, 2004, 01:25 PM
Just attach the Oracle tables into the Access MDB, run some insert queries to populate the Oracle tables.....