error 3759 : data truncation error with decimal data

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

Bryan Reich [MSFT]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SCALING OF DECIMAL VALUE RESULTED IN DATA TRUNCATION 3
Access stripping decimal places in query 1
Scaling results in data truncation 2
Access Project SQL Import csv 4
Access data truncation error with decimal data (error 3759) 3
Comparison of text field values wtih Decimal symbol gives error 2
Scaling of decimal value resulted in data truncation 2
Decimal Truncation Issue upon Import - Access 2007 1

Top