"Double hop" problem

[GP]

I have the following set up:
- Source data in Oracle database table.
- Query in MS Access reading the Oracle data through Access Linked Table.
- Excel file reading the Access query as Linked External Data.

When I update the Excel query, it returns only the field names form the
Access query but no data.

I have done some testing as follows:
- The Access query runs fine in Access are returns correct data.
- The Excel query runs fine and return correct data when the Access query
uses a normal Access table as the data source. The problem only arises when
the Access query is using the Oracle table are a source.

So it would appear that the problem is associated with the “double hop†to
get the data.

Any ideas what is wrong?

G

 

[Klatuu]

Why not just go directly to Oracle from Excel?

 

[GP]

Becuase the query is in Access.

Why not just go directly to Oracle from Excel?

 

[Klatuu]

You could do the same query in Excel
From the menu select Data, Import External Data, New Database query.

 

[GP]

OK, I'll give it a try.

Thanks.

You could do the same query in Excel
From the menu select Data, Import External Data, New Database query.