Re: Oracle7.3 & MS Access
From: Arman Rawls <arawls_at_bellsouth.net>
Date: 1998/01/28
Message-ID: <dkwz.1210$mL4.1121569_at_news1.atl.bellsouth.net>#1/1
Date: 1998/01/28
Message-ID: <dkwz.1210$mL4.1121569_at_news1.atl.bellsouth.net>#1/1
TimKArnold wrote in message
>If you you are trying to convert data from Access to Oracle
>I've done this many times.
>1. create your table in Oracle using SQL*plus. No trigger.
> It is easier if the column names match your access table
> and the data types match.
>2. Attach to Oracle in Access via ODBC.
>3. Create an append query that appends records from Access
> to Oracle.
>3. Run it.
>Done.
Watch out for this if you have a lot of records. You can easily max out your rollback segments if you have a lot of data. An Append query treats this as one transaction and will not commit until it finishes (successfully). Received on Wed Jan 28 1998 - 00:00:00 CET