J
JohnS
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!
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!