Exporting Access DBs to ORACLE
From: Rafael Algara Torre <ralgara_at_Davinci.mty.itesm.mx>
Date: 1996/07/11
Message-ID: <4s1rod$gjo_at_news.mty.itesm.mx>#1/1
Date: 1996/07/11
Message-ID: <4s1rod$gjo_at_news.mty.itesm.mx>#1/1
Hi,
I have an MS Access DB, full of data.
Around 2500 regs. I need to export all
the table structure and info to an ORACLE
system (on UNIX). I have no network installed
in the Access machine, so I have to generate
a text file. Once I have the table structure
into ORACLE, am I supposed to do 2500 UPDATEs?
If so, I'm thinking about writing a script.
There is ODBC as well, but as far as I know
it's for network distributed interchange of
information.
Thanks in advance. Please e-mail if possible
--Received on Thu Jul 11 1996 - 00:00:00 CEST
--------------------------------------------
Rafael Algara Torre ralgara_at_dgicii.mty.itesm.mx ITESM Campus Monterrey Centro de Investigacion en Informatica Me‚xico, 1996.
--------------------------------------------