Re: populate Oracle from Access

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Mon, 28 Dec 1998 13:51:29 GMT
Message-ID: <36878b60.6070559@newshost.us.oracle.com>

On Mon, 28 Dec 1998 12:01:12 GMT, clarkb_at_scmb.co.za wrote:

>Hi Gurus,
>
>Is there a way to populate Oracle (ver 7) from an existing Access Database ?
>The Access base that I need to move accross has a few thousand records. I need
>a simple way to transfer the required fields. Any help would be greatly
>appreciated.

Probably the easiest way to do this would be:

1. Create ODBC datasource for your remote Oracle7 database.
2. Create an Oracle table with similar structure to the Access table
3. Attach the remote Oracle table (Get External Data -> Link Tables)
4. Create an Append Query, similar to INSERT INTO Oracle_Table SELECT ... FROM Access_Table
   >
   >TIA.
   >
   >Bruce.
   >
   >-----------== Posted via Deja News, The Discussion Network ==----------
   >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
   

Thanks!

Joel

Joel R. Kallman Oracle Government, Education, & Health

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Mon Dec 28 1998 - 07:51:29 CST