I have succesfully used range values as parameter values with MS Query and
Excell2007. Suddenly this technique no longer works and when testing the
queries I get the error message "SQL data type out of range". If I copy and
paste the cell value into the criterion box of MS Query to replace the
parameter prompt all works as expected. I get the same message with data
types ranging from dates to simple strings. The SQL string seems to be the
same as the older working versions.
Please help!