Re: Import Access into Oracle

From: <bsonia_at_my-deja.com>
Date: Tue, 12 Sep 2000 13:57:28 GMT
Message-ID: <8plcnt$f0u$1@nnrp1.deja.com>

Assuming you have connectivity to Oracle from Access through ODBC, right click on the table in Access that you want to export and select the save as/export option. Select the 'To an External File or Database' option. In the Save as type drop down box, select ODBC database. Enter table name and then select the odbc data source you use to connect to the Oracle db.

Word of caution: Make sure the table and column names are in caps before you export or you won't be able to do anything with it once it is in Oracle.

Hope this helps.

Bill Sonia

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 08:57:28 CDT