Hello,

I am doing a simple select query between a SQL database table and an Excel
file.  When I join the two appropriate fields, I receive a "type mismatch in
expression" message.  The Excel file is formatted as text and I have
performed this identical query with other Excel files and not had this
problem.  I have also tried formatting the cells as every other type in case
I was wrong, and received the same error each time.  I have also formatted a
blank worksheet as text and pasted in only the values and I still receive
this type mismatch error.  Does anyone have any suggestions?  Please??  I am
going mad!