Re: Importing data from Access
Date: Thu, 28 Jun 2001 15:36:33 GMT
Message-ID: <5aI_6.30636$ID2.8173406_at_typhoon.jacksonville.mediaone.net>
use an ODBC connection.
"Aidan" <ahumphreys_at_ZAPprocoma.de> wrote in message
news:KBH_6.4942$dG3.116447_at_news.easynews.com...
> Beginner's question: if a client supplies me with database in MSAccess
> format, what is the best way to merge that data with an existign Oracle
DB.
> I know that many records are duplicated in the Oracle db but I can easily
> reject those on the basis of key comparison.
>
> My question is must I dump the Access and write a routine to import the
data
> and then to merge it - or is there a direct way to address the access data
> via an Oracle/Access link and perform the merge accross the databases. I
> guess you cannot run an SQL query across two databases, is that right?
>
> A
>
>
>
Received on Thu Jun 28 2001 - 17:36:33 CEST