Re: Importing Access files into Oracle
Date: 1995/12/07
Message-ID: <DJ79Mz.I6r_at_world.std.com>#1/1
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