Re: how to load MS Access db into SQL

From: Brian W. Chester <bwchester_at_home.com>
Date: Tue, 21 Mar 2000 13:28:13 GMT
Message-ID: <NNKB4.19785$a27.283684@news1.rdc1.mb.home.com>

roopa,

You can do this in one of several ways. You look at the MSaccess migration guide found at http://technet.oracle.com (membership is required and is free) or you can manually create the desired table structure in an Oracle schema then use an Access Macro consisting of runSQL items (statements) which perform inserts from access to Oracle. This is a good method if you want to change the table structures and have greater control over object creation including space allocation, indexes and the like.

You will require the Oracle ODBC drivers to perform the transfer using the macros. You can download the odbc driver from technet.

HTH Brian

<kad_roopa_at_yahoo.com> wrote in message
news:38D74F06.2AD2ADCF_at_american.edu...
> hi,
>
> Could someone tell me as to how I can import MS Access database to
> Oracle8i database.
>
> thanks in advance for the help,
> roopa.
>
Received on Tue Mar 21 2000 - 07:28:13 CST