Re: Transfering Access 2000 mdb into Oracle 7/8

From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Wed, 6 Feb 2002 13:28:01 -0800
Message-ID: <a3s6sa$7u4$1_at_spiney.sierra.com>


Access may create the tables with lowercase tablename/field_names. In order to use them, you must surround the field names in quotes.

This is not Access 97 versus Access 2000 specific: Access 97 would do this as well.

"Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message news:a3nf3q$e908$3_at_as201.hinet.hr...
> It is true that after transfering tables from Access into Oracle you
> have to enclose names of some tables in quotes. However, with Access 97
> I was able to transfer all tables but with Access 2000 wont to transfer
> them all!
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> news:3c5ee67a$0$18472$afc38c87_at_news.optusnet.com.au...
> > It's hard!
> >
> > I bet a lot of those error messages were for tables that had
> > auto-incrementing sequences in them: since Oracle and MS data types
> don't
> > correspond 1-for-1 (and auto-sequences are a classic
> no-corresponder!), you
> > do get problems. Last time I did it, I went through the entire Access
> > database renaming every column so that names were all in uppercase.
> Same
> > for the tables themselves (otherwise, you have to enclose your table
> names
> > in quotes when you start running queries - select * from 'emp' for
> example).
> > Also, any autoincrementing sequence was replaced with a boring old
> number
> > field (and triggers had to be hand-crafted afterwards to populate the
> > relevant fields in Oracle). Quite hard work.
> >
> > Oracle used to supply a conversion utility, but you had to pay for it,
> and
> > I've forgotten what it was called, and don't know whether it is still
> > current (someone here will know). I tried it once or twice: you still
> have
> > to do quite a lot of work by hand afterwards, even so.
> >
> >
> > "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message
> > news:a3mmbq$d314$1_at_as201.hinet.hr...
> > > What is the easiest way to transfer Microsoft Access 2000 database
> into
> > > Oracle7 (7.3.4) or Oracle8i (8.1.7) database? I have tried Microsoft
> > > ODBC and original Oracle's ODBC drivers but without success! I only
> get
> > > some strange error messages! Sometimes, with some tables it works
> but
> > > not with all tables.
>
>
Received on Wed Feb 06 2002 - 22:28:01 CET

Original text of this message