Re: Oracle and Access

Export the data from Access to a flat file (maybe comma delimited). Then use SQL*Loader to load the data into Oracle.

HTH,
Brian

Mohammad wrote:
>
> Hi
>
> I have to read information from Access 97 DB and insert record to
> Oracle9i table. I used ODBC for Access and Oracle and I did that. It
> is working find but it is working very very slow!!!!!
>
> Could you please tell me any other way to do that job and faster or
> maybe I missed same setting for ODBC.
>
> Thanks for your help.
>
> Hakim
 

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"