namwan
23rd February 2007, 04:36
I use program using VB to insert new item from excel file. It has error
"string or binary data would be truncated".in every table that refer item.
How i solve this problem?? Thank you.

mark_h
23rd February 2007, 14:14
Post your code and maybe one of the VB experts might see a problem.

sukesh75
24th February 2007, 08:04
The length of the field that is being entered from excel exceeds the limit of the field you are populating in the particular table(s) OR the datatype of the field in excel doesnt match with that of the field in the table(s) you are poplulating...

sk