>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

How are you doing the insert?