Re: How to Upload Acess or MSSQL DB to Oracle DB
Date: Fri, 17 Nov 2000 23:12:40 -0500
Message-ID: <3a16002f$0$35379$53a6afc1_at_news.erinet.com>
If you have the oracle ODBC driver and SQL*Net on your PC (or network) where your Access container exists, create an ODBC connection to your Oracle database. Once you have this open your Access container, export the table to the ODBC database (oracle server). Two cautions: make sure your table and column names in the Access container conform to Oracle nameing standards and that they are uppercase; your primary keys and relationships (idexes) will not migrate via ODBC.
Orville Walters
Srimal wrote:
> Hi all,
>
> I need to upload a non oracle database to a oracle database.
> Please give links that I can get help.
> or please help on this.
>
> Thanks in advance.
>
> Srimal
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Nov 18 2000 - 05:12:40 CET