You have data in the Excel spreadsheet that is confusing Access. The problem
here is that if a cell in Excel is formatted as General and not data has been
entered, Access will see it as Null. There could be other issues with
numeric data type matching, but I have not experienced these.
To avoid the Nulls causing problems, wrap all your numeric fields in your
query with the Nz function. For example, we have a column in the Excel table
named SomeMeaninglessNumber, so in the query in the column where you are
using SomeMeaninglessNumber, in the Field row:
Exp1: Nz(SomeMeaninglessNumber,0)