Type mismatch in JOIN expression.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am fairly new to using access, so please be patient.

I have two spreadsheets (Excel) and I have created a linked table in Access
to each of the spreadsheets. I have multiple worksheets in one of the
spreadsheets, so from that spreadsheet there are linked tables in Access to
several of the worksheets. I have queries for each of the tables to find
certian data that is common to both spreadsheets. The first query works just
like I need it to. Here is my problem: all the queries after the first one
return an error: "Type mismatch in JOIN expression". I have joined one column
in one table to a corresponding column in another table. I have also verified
that the format in both spreadhseets for those columns is the same. (Both are
a number format). I can open the spreadsheets and format the columns (to the
same format they already are), and then open the queries, and they will all
work properly. However, after I save and close the spreadsheets only the
first one will work again. I open the spreadsheets back up and check and the
column formats are correct and are matched.

Can someone please help me figure out why this might be happening?

Thank you.
 
Sometimes the Excel to Access link is too helpful like having it say my text
column is numbers. In that case I put in a false record at the top that
contains text to force it to be text.
Access has more that one kind of numbers - Byte, Interger, Long Interger,
Single, and Double Precission.
Look at the design of the linked Excel table in Access even though can not
change the design and see what Access thought your column was.
Put false data in the first row so that they all will appear to be the same.
 
Thank you for your reply. I have tried implementing your suggestions, but I
have not been able to resolve this issue yet. If there are any other ideas I
would like to hear them.
Thank you.
 
Back
Top