Re: Oracle to Access connectivity

From: Randy Harris <randy_at_SpamFree.com>
Date: Tue, 04 Oct 2005 04:01:00 GMT
Message-ID: <08n0f.203$E46.134@newssvr23.news.prodigy.net>

"joe bayer" <joebayerii(nospam)@hotmail.com> wrote in message news:8Sk0f.4877$YH6.3070_at_trnddc06...
> I have one oracle database 9206 on RedHat Linux (3.0), and an access
> database 2003 on WinXP, every night, we need to get the data out of access
> database into a flat file and then use sqlload to load the data into
Oracle.
>
> In there any better way of doing this, like dblink?
>
> Thanks very much for your help.
>
>
>

In Access - link the Oracle table. Do an append query. Received on Mon Oct 03 2005 - 23:01:00 CDT