Re: MS-Access to Oracle

Darrell_Coons_at_.mc.xerox.com (Darrell Coons) wrote:

>I'm sure this has been answered before, but being new to this game I'll
>ask it again:
 

>How do I convert an MS-Access table to Oracle? Is there a way to export
>from Access into a format that can be directly imported into Oracle?

You will need ODBC and SQLNET installed. This needs setting up with a connection string to attach you to the Oracle system. From here simply export the tables as <SQL Database> - select table and login.

You may want an Oracle administrator to setup index and primary keys on the Oracle table, as well as update triggers to speed the processing of adding searches etc.

hope this helps

Steve and Bernard
Manchester, England Received on Fri Mar 29 1996 - 00:00:00 CET