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

From: <rock_cogar_at_my-deja.com>
Date: Tue, 28 Dec 1999 23:00:27 GMT
Message-ID: <84bevc$lch$1@nnrp1.deja.com>

Look at a product from Bunker Hill Software called: "Scriptoria for Oracle". It works really well for moving entire Access 97 databases into Oracle 8.1.5 schemas.

Rock_cogar_at_my-deja.com

In article <946068279.17549.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> 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
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 28 1999 - 17:00:27 CST