Access Link to Excel

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

I have 2 tables in Access. One of these is linked to an Excel worksheet. I
would like to create a form that shows information from the Access Table and
3 fields from the Linked Access Table.

Primary Key is StudID in the Access Table.
There is also a double numerical field in the Excel worksheet (and the
linked Access table) that contains the same number.

When I tried to set a relationship for StudID, my only choices were
one-to-many of "indeterminate". (I've tried them all - although what I need
is a one-to-one relationship).

When I open the form, instead of the 8 records I expect to see, I get 80 (10
for each person).

Question is, can I have a form that contains info from the Access table and
the linked table?

Thank you - Jamie
 
Hi Jamie,

What's happening here is that a one-to-one relationship can only be
created when all the fields involved have unique indexes - but since
linked Excel tables aren't indexed you can't have a one-to-one
relationship involving one. (And since it appears that there are more
rows in the linked table than in the native table, you don't have a
one-to-one relationship in reality anyway.)
 
John -

Thanks for your answer.

Jamie

John Nurick said:
Hi Jamie,

What's happening here is that a one-to-one relationship can only be
created when all the fields involved have unique indexes - but since
linked Excel tables aren't indexed you can't have a one-to-one
relationship involving one. (And since it appears that there are more
rows in the linked table than in the native table, you don't have a
one-to-one relationship in reality anyway.)
 
Back
Top