Re: Importing Access files into Oracle

I am simply using an append query with an attached oracle table, but it is pretty slow for tables over ~1mb in size.

Josh

ramirez_at_iastate.edu (Dr. Richard G. Ramirez) writes:

>I have done this using Access' export and ODBC, but only for small
>tables. I don't know how efficient it would be for large tables.
 

>Richard
 

>In article <jmallenDJ3wK2.3yt_at_netcom.com>, jmallen_at_netcom.com (John Allen) writes:
>|> I have done this with a 57MB Access database. I simply exported into
>|> ascii comma delimited text enclosed by vertical bar. I then ran SQL*LOADER
>|> to load the data into Oracle.
>|>
>|> Pretty straightforward.
>|>
>|> -- John Allen
>|>
>|> Denise Noble (denisen) wrote:
>|> : We're developing a new database in Oracle 7.1.6. We are currently storing our
>|> : files in MS Access. Has anyone imported Access files into Oracle? If so, is
>|> : it a relatively simple process? Thanks in advance
 

>|> : Chris Wasser
>|> : chrisw_at_polypogon.CNR.colostate.edu
>|>
>--
>Richard G. Ramirez, Ph. D.
>Assistant Professor of MIS
>Iowa State University
  Received on Thu Dec 07 1995 - 00:00:00 CET