Type mismatch even though types are the same

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

Guest

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!
 
Does Excel even have datatypes? I know you can format a cell, but does it
truely conform to an Access data type?

Try importing the data into an Access table. See what datatype it gives for
the column. You might think its a number, but there's actually text in it.
 
Back
Top