Table Join Problem

[CRobledo]

Hi,
I have 2 excel sheets linked to my database and in a query in access I am combining them into one by using a the join property. My issue is that when I click run query, all the data from the student table populates but the data from the link does not. This issue does not occur if the tables are local. Unfortunately for the purposes of this database it has to be a linked table. Does any one know how to fix this?

[pbaldy]

If I had to guess, the data in the joined columns does not match exactly.

[isladogs]

You are using a left join so it's getting all records from the left table even if none exist in the right.
If you change both to inner joins, do you get any records from the query result?