ODBC Error when importing to Excel

[sahafi]

I have an Access query with a calculated field, that when I tried to import
into Excel | Data >> Import Data >> New MS Query, I received this error:

[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null)

I do have another query that imports data OK. Any idea/resolution for this
error?

I have posted this on the Excel group as well.

Thanks.

 

[Klatuu]

Check the calculation. Somewhere in it, you are getting a Null value.

 

[sahafi]

I have checked the entire query, and I only see "0" values. I have tried
using "Nz" and "IIF(IsNull(....)) but nothing seems to work. In the mean
time, I can import any other query that doesn't have any calculating field in
it.


Thanks.
--
when u change the way u look @ things, the things u look at change.

Check the calculation. Somewhere in it, you are getting a Null value.

I have an Access query with a calculated field, that when I tried to import
into Excel | Data >> Import Data >> New MS Query, I received this error:

[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null)

I do have another query that imports data OK. Any idea/resolution for this
error?

I have posted this on the Excel group as well.

Thanks.