Re: I want to use Access with Oracle
From: TurkBear <johng_at_mm.com>
Date: 2000/07/28
Message-ID: <39829e2b.5653198_at_news>#1/1
Date: 2000/07/28
Message-ID: <39829e2b.5653198_at_news>#1/1
You can use ODBC and export the Access table(s) to Oracle...
However,
Be SURE you name all columns and the table_name in UPPER CASE before exporting
or else they will be a pain-in-the-a.. to use with SqlPLus and other Oracle
tools...Also watch for data types...set yours in Access to those that match (
if possible) Oracle data types...
hth and Good Luck
( I have done this several times - both ways-with Access97 and 2000, Oracle 7
and 8 )
"Zeeshan Basharat" <zbasharat_at_hotmail.com> wrote:
>I have a database in MS Access 2000 and I want to transfer all the data in
>that database file to SQL's table.
>I am confused what should I do?
>Please help me???
>
>
Received on Fri Jul 28 2000 - 00:00:00 CEST