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
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