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


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

--

--------------------------------------------
Rafael Algara Torre ralgara_at_dgicii.mty.itesm.mx ITESM Campus Monterrey Centro de Investigacion en Informatica Me‚xico, 1996.
--------------------------------------------
Received on Thu Jul 11 1996 - 00:00:00 CEST

Original text of this message