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

sqlite-odbc write conflict 2
Adding data to MS Access from csv file 0
Creating a Chart on form from selected data in query. 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Error "3759 Scaling of decimal value...." when importing a table . 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
SCALING OF DECIMAL VALUE RESULTED IN DATA TRUNCATION 3
Creating a Search using a combo box and then creating a report. 4

Top