Re: To Oracle From Access ???.mdb

Two ways:
By using ODBC:
make a connection to Oracle in your Access database and export your tables to Oracle. Warning: column names are taken as is, if they are in lower case (and/or with spaces), you can only use them in Oracle by embedding them in ". You should change column names in Access first (uppercase them and replace the spaces by an underscore)
By using the Access migration wizard that comes with Oracle. I have used it only when it was in it's immature stages, it backed out on me, so I can't really advise you on that one.

Hth,

Sybrand Bakker, Oracle DBA
webnet wrote in message <7el768$aqa$1_at_news2.kornet.net>...
>1) local database is Access addr.mdb
>2) server database is Oracle 7.3x
>
>How can i upsizing ?
>Hmm....
>Is it mdb->txt->excel->Oraxel->Oracle ????
>
>Please ............Anybody know that....!!!
>
>
>
>
Received on Fri Apr 09 1999 - 12:14:25 CDT