ODBC Error when importing to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.


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

sahafi said:
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.
Click to expand...
Click to expand...
 
Back
Top