Re: Importing data from Access
Date: Sun, 22 Jul 2001 17:06:04 GMT
Message-ID: <0KD67.24010$cK1.7357149_at_typhoon.jacksonville.mediaone.net>
Use the Oracle ODBC driver to append the data from access to Oracle.
"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 Sun Jul 22 2001 - 19:06:04 CEST