Re: Translation from MsAccess97
Date: Sat, 10 Apr 1999 21:11:40 +0100
Message-ID: <370FB07B.29D7C0F2_at_computer.org>
You can also use Access migration toolkit provided by Oracle Data & Migration services, available for download free of charge.
If you do not find it feel free to contact me.
[Quoted] To be even more incisive: in future don't use Microsoft products for database applications !
Herman Viaene wrote:
> I can imagine two ways:
> 1. use ODBC connection in MS-Access and make a VB script where for each
> table you issue the command : create table ORACLE_Table as select * from
> Access_Table
> or (perhaps easier)
> 2. export all the data in CSV files from Access, create directly in Oracle
> the necessary table structures and then use SQLLoader to import the data in
> the Oracle tables
>
> Free advice: in future don't use Access anymore for any serious database
> application
>
> Herman Viaene
>
> jun_p_at_yahoo.com wrote in message <7emg1r$nio$1_at_nnrp1.dejanews.com>...
> >How do I translate an existing database in Access97 to Oracle 7.3?
> >
> >-----------== Posted via Deja News, The Discussion Network ==----------
> >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Apr 10 1999 - 22:11:40 CEST