Re: Importing Access files into Oracle

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