Re: Convert Access Tables to Oracle????
From: Fai Lau <pflau_at_ibm.net>
Date: 1996/04/30
Message-ID: <4m4fb0$1486_at_news-s01.ny.us.ibm.net>#1/1
Date: 1996/04/30
Message-ID: <4m4fb0$1486_at_news-s01.ny.us.ibm.net>#1/1
Robert Städter <staedter_at_boku.ac.at> wrote:
>As for your question about how to 'convert' the Access tables to Oracle, the only way
>I can think of is to export each Access table using a fixed-length or delimited
>Ascii format, creating each table in Oracle and using SQL*Loader to load the exported
>files.
Connect to Oracle via ODBC, and use Access export. The table structures are created on the fly. Make sure you have enough space for rollback data. That's all folks.
-Fai Received on Tue Apr 30 1996 - 00:00:00 CEST