Accessing data from an MS access db from an Oracle UNIX server

From: Andrea M. Segovia <andrea_at_mun.ca>
Date: 26 Nov 2003 08:06:00 -0800
Message-ID: <7589088f.0311260806.dc42dce@posting.google.com>

Hello,

I am a newbie to Oracle databases....

We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access databases who would like to share their data using this visualization tool but do not want to import their data into the Oracle server back-end.

Is there any way we could use the Oracle backend to query the MS Access databases and merge this data with other data in the Oracle back-end for presentation by the visualization tool? Perhaps through ODBC or some other standard?

The Oracle back-end is a a Tru64 UNIX server running Oracle 8i.

Any input would be appreciated.

Andrea Segovia
A/Project Manager Received on Wed Nov 26 2003 - 10:06:00 CST