Yeah, I'm having the same problem. I try to import some data from access and I get the data mismatch error 3464. Below is the code that has the Data Type Mismatch in the criteria expression:
'Imports a temporary table containing the data
DoCmd.TransferSpreadsheet acImport...