Discussion Locked

Access 2002 and Discoverer (Oracle)

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I asked this question on the Office board and got no response. I hope someone here can help me.

I'm trying to link to Discoverer (*.dis End User Layer {EUL} Queries)

When I try to import the datasource I need into Access 2002, these are the steps I'm using.

File, Get External Data, Link Tables
Change Files of Type to ODBC databases
Navigate to the Network Drive and Folder where the datasource is . . . .
but I can't see anything there. I know it is there, I can see it in Windows Explorer.

I see the Select Data Source dialog box says "Select the file data source that describes the driver that you wish to connect to. You can
use any file data source that refers to an ODBC driver which is installed on your machine."Am I to assume that I don't see it because I'm missing a driver? What specifically do I need and where would I find it?

Thanks for your help.

4 replies

by sl-campbell

In order to install missing ISAM drivers you need to take your MS ACCESS or Office installation disk, start set-up, select Add/Remove components, select data access, select options, options, and then installed the missing driver.
If you do not findthe driver here, then you will need to install the one from the mfg.

by learneverything

Thanks, sl. But I need to know what I'm looking for. A driver name or something?? Apparently, Discoverer is not commonly used to link to Access... I've asked several ngs and no one seems to know.

This discussion is closed to new replies.