Data Truncation Error

[NigelRS]

Hi Folks,

I am using V8.5.2. business multisite and I am trying to link it up to an external database (namely an Excel 2007 spreadsheet).

Each time I link it up and go to update I get a Data Truncation warning, I have looked at the fields I am linking to (and they don't exceed any maximum character lenght), I have double checked the field type is set correctly (e.g. text/number) and I am not sure what else I can check.

I have found no other thread on here with this as a problem so I am asking for help!

Thanks,

Nigel

[Duncan Rounding]

You need to recheck that the linked data is not too long for one of the database fields. Try a test with something simpler to try and narrow down the problem.

[Darren B]

if you open your mdb in access you can see the number of characters allowed for the cells

D

[completerookie]

fairly certain product codes are at most 20 characters, but if you want to use duplicates you need to restrict it even further as it puts a "!###" at the end where "###" is the next available duplicate number for that product.
realistically, you need to have a max 18 characters for nine duplicates, and 17 characters for 99 duplicates of any one product