Re: how do I import MS Access database into Oracle 8i?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 24 Dec 1999 21:43:32 +0100
Message-ID: <946068279.17549.0.pluto.d4ee154e@news.demon.nl>

There are two ways do this:
Oracle provides an MS-Access migration wizard. The other option is use ODBC, and export your Access tables to the Oracle database via an ODBC connection.
Warning: all your Access identifiers (table names, column names) need to be in uppercase without spaces or you need to enclose everything in "" in Oracle. The Oracle Migration Wizard takes care of that automatically.

Hth,

--
Sybrand Bakker, Oracle DBA
Prabha Chidambaran <prabha_at_rcn.com> wrote in message news:840kke$mjv$1_at_bob.news.rcn.net...
> Is this possible? Or can I do this only in O8 personal edition?
>
> thanks,
> Prabha
>
>
Received on Fri Dec 24 1999 - 14:43:32 CST