Linking table gets numeric field overflow

  • Thread starter Thread starter raviyah
  • Start date Start date
R

raviyah

I have linked an Excel worksheet to an Access table and am running an append
query to move the data into another access table. The first time I run the
query all works fine. Then I get the numeric field overflow error.

Following suggestions from other posts, I included a NZ([fieldname],0) in
the query for my 2 numeric fields.

Does this error only happen for numeric fields (I have one numeric-double
and one date field. both seem to have good data) and lots of text fields

Any other ideas I can look for?
 
I have linked an Excel worksheet to an Access table and am running an append
query to move the data into another access table.  The first time I runthe
query all works fine. Then I get the numeric field overflow error.

Following suggestions from other posts, I included a NZ([fieldname],0) in
the query for my 2 numeric fields.

Does this error only happen for numeric fields (I have one numeric-double
and one date field. both seem to have good data) and lots of text fields

Any other ideas I can look for?
Click to expand...

not sure my two cents will buy much, but what if you cast the value
explicitly using one of the conversion functions: CDouble() CLong()
CInt()... and then appending that calculated value to your table?
 
Thanks for the idea, but it didn't solve the problem. Any other ideas?

[email protected] said:
I have linked an Excel worksheet to an Access table and am running an append
query to move the data into another access table. The first time I run the
query all works fine. Then I get the numeric field overflow error.

Following suggestions from other posts, I included a NZ([fieldname],0) in
the query for my 2 numeric fields.

Does this error only happen for numeric fields (I have one numeric-double
and one date field. both seem to have good data) and lots of text fields

Any other ideas I can look for?
Click to expand...

not sure my two cents will buy much, but what if you cast the value
explicitly using one of the conversion functions: CDouble() CLong()
CInt()... and then appending that calculated value to your table?
Click to expand...
 
Back
Top