I perform a lot of Excel database queries on a mySQL database using mySQL ODBC driver version 3.51. I can only seem to add filter criteria successfully to text fields. When attempting to apply a filter criteria to a numeric field I receive an error. A generic example of the error is as follows:

"Column 'table_name.field_name' can't be used with the operator 'is greater than'"

I am able to use other tools such as phpMYADMIN and anySQL Maestro to successfully run SQL queries with the filters I desire, so it seems to be an issue specific to Excel.

I know that I could use those other tools to get the results and then import them into Excel, but I would prefer to keep it all internal to Excel in order to automate via VB macros.


Any replies would be greatly appreciated.