Re: Data Migration from Access 2.0 to Oracle 7.3

kif_at_worldnet.att.net wrote:
>
> Which is the optimum method of migrating data from Access to Oracle
 server.
>
> 1. SQL Loader
> 2. Using Access' export feature.
> 3. Other

Charles Crow wrote:
>
> There is an Migration Access tool that comes with 7.3.2. see your cd.

We used a combination of all of the above!

Our Access database was about 100,000 rows, the migration tool took all day and then failed not having done half a job. We've used it successfully for 10/20,000 row databases.

Our procedure was:

1. Use migration tool to transfer structure only, no data.
2. Export Access data into csv format.
3. Use SQL*Loader to import csv file.