Re: Migration

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 3 Jun 1999 19:45:31 +0200
Message-ID: <928431838.26759.0.pluto.d4ee154e@news.demon.nl>

Setup an ODBC connection to the target Oracle database. Make sure you get rid of spaces in your column names and make sure all column names are in uppercase. The ODBC driver doesn't convert them. Oracle allows them but you will be forced to surround everything, as follows "emp table". This will soon develop into a nightmare. Then from Access export the table (or a query on that table) to Oracle. That is all.

Hth,
Sybrand Bakker, Oracle DBA, former Access database repair guru (phew!)

speedy wrote in message <37572D15.E40BAB37_at_pacific.net.sg>...
>hi,
>
> May l know how do l use ODBC to migrate data from access to Oracle
>?
>
>Thanks
>with regards
>Steven
>
>
Received on Thu Jun 03 1999 - 12:45:31 CDT