Linking table gets numeric field overflow

[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?

 

[pietlinden]

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?

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?

 

[raviyah]

Thanks for the idea, but it didn't solve the problem. Any other ideas?

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?

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?