>I am developing a program that takes data from VFP 6.0 tables and inserts it into an Access 2K database. Everything is going in except I get trailing spaces at the end of character fields. For example there is a field named "Color" in the Access database defined with a field size of 20. I insert "Red" into this field and there are 17 trailing spaces. ALLTRIM doesn't make a difference. If anyone can tell me how to remove these spaces, I would greatly appreciate it.
>
>Thanks,
>Steve
Hi Steve,
Access behaves just how it should behave. For example, the length of the Access field is 20 and you insert a string "Red", which length is 3. So Access 2K right justifies the string. You result is "Red" + 17 trailing spaces.
HTH, Igor
Igor Gelin
Database Developer