Re: Importing data from Access

From: Tony Hunt <tonster_at_bigpond.net.au>
Date: Mon, 30 Jul 2001 13:43:36 GMT
Message-ID: <cwd97.74804$Xr6.345192_at_news-server.bigpond.net.au>


Aidan

If your MS Access database is not too big and you're happy to leave it there, you can quite easily LINK TABLES to access using the ODBC drivers.

I have a lot of transaction data in Foxpro tables and Customer Info in an Oracle database. I just use Access to link to all the different types of tables and run queries across up to 3 different types of databases using Access.

Tony

"Steve Long" <slong3_at_mediaone.net> wrote in message news: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 Mon Jul 30 2001 - 15:43:36 CEST

Original text of this message