Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

scaling of decimal value resulted in data truncation

Status
Not open for further replies.

TLegend33

IS-IT--Management
Jun 16, 2003
1
0
0
US
I am attempting to import a table into access 2000 via odbc that has decimal values (i.e. 34.87656889) in the source table. I recieve the error:
'scaling of decimal value resulted in data truncation'
when I attempt to import this table. This error does not occur in access 97. How can I successfully import this table into access 2000? Also, is there any method where I can define a fields description prior to importing it via odbc?
Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top