[ODBC Microsoft Access Driver] Error

[CopperWire]

I'm able to run a query in Access successfully but I get a driver error when I try to access the query in Excel. I'm trying to use the query to create a pivot table in Excel?

The error message is "[Microsoft] [ODBC Microsoft Access Driver] Invalid value for cast specification on column XX."

Any ideas?

 

[PHV]

Any chance you could post the SQL code you try to execute via ODBC ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[CopperWire]

It seems to be a data problem. We were able to get around the error by doing the following.

We created a make table from the query. Then we converted the data type of the problem column to text and back to a number. Then it works.

I don't know why this happens, but it does frequently. What a pain!