Linking Oracle view with Access database

[Budjette]

Hello,

I want to link an oracle view to a table in access. I have 4 starting points and 4 endinG points. Example:
table1(Oracle) table2(Access)
CC ---------> CC
DEPARTMENT --> DEPARTMENT
PERIOD ------> PERIOD
YEAR --------> YEAR
When I link the first one, CC to CC, I have no problem. But when I link DEPARTMENT TO DEPARTMENT, I get this error: "invalid file link. Not all fields in the same index expression." How do I get my links to work??? Or, can I use instead a excel sheet (my data is in a excel sheet too). Thanks.

Budjette

 

[synapsevampire]

I assume that this is still the case:

http://support.crystaldecisions.com/library/kbase/articles/c2003886.asp

Consider linking (not importing) the Oracle tables into the MS Access database and creating a query from the different datasources with MS Access.

Use that Query in CR, that's the simplest way.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Budjette]

Thanks!

You're right! That way, it's working fine. I'll keep that in mind.

Bye,

Budjette