Re: migrate data from access to oracle

On Wed, 12 Jan 2000 13:31:02 GMT, bmolish_at_btsquared.com wrote:

>
>
>I have 30K rows of data in an access database that I need to transfer
>over to oracle is there an utility to do this
>

A slow, but easy way to do this is to export via the ODBC driver directly into Oracle. A faster alternative would be to export to a text file (comma delimited, optionally enclosed by quotes is a good one) then use SQL*Loader to pump the data into Oracle. You SQL*Loader control file will then look something like:

LOAD DATA
INFILE 'myexport.csv'
TRUNCATE
-- or APPEND
INTO TABLE mytable
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
  col1,
  col2,
-- YOU can also format columns too like so   col3 "UPPER(LTRIM(RTRIM(:col3)))"
) Received on Wed Jan 12 2000 - 18:44:08 CET