Need help! - Trying to use MS Query in Excel to extract MS Access

[Guest]

Hi all:
I am trying to extract some data from an Access query using MS Query while
in Excel. The access query will extract the data from the data source
without any problems. (I can even cut and past the data from the access
query to the excel spreadsheet.) The problem arises when I go to refresh the
data in the excel spreadsheet using the MS query. I get the following error
message:

"[Microsoft][ODBC Microsoft Access Driver] Invalid character value for cast
specification on column number 4 (SumofSumofTransValue)"

Can anyone shed some light on this problem? Everything worked up to about
two days ago.

Thanks,
FatMan

 

[Jamie Collins]

I am trying to extract some data from an Access query using MS Query while
in Excel. The access query will extract the data from the data source
without any problems. (I can even cut and past the data from the access
query to the excel spreadsheet.) The problem arises when I go to refresh the
data in the excel spreadsheet using the MS query. I get the following error
message:

"[Microsoft][ODBC Microsoft Access Driver] Invalid character value for cast
specification on column number 4 (SumofSumofTransValue)"

Can anyone shed some light on this problem?

Post your SQL code.

Jamie.

--

 

[Guest]

The problem lies with the Access table. The data type is probably decimal,
and you are having trouble pulling negative values?
Change the field type to double or single integer and your problem will
dissappear!