error 3759 : data truncation error with decimal data

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

Hi to all of you,

I am doing a query with Access 2000. It is a table creation query that takes
decimal data from
an ODBC linked table. Then I have got the error message : "data format
convertion has created
a data truncation (error 3759)."
I really don't know what to do. When a remove the decimal column from the
query, everything is Ok.
If someone has an idea, it would be of a great help.
Thanks for any help.

Bye.
Fred.
 
Please post the query as well as the table schema for both the table you're
pulling data from and the table you are storing data to, in particular the
data types for the field in question, where it's coming from and where it's
going to.
 
Back
Top