>Hi all,
>I am trying to insert records from vfp table into Timberline/Sage/Pervasive database.
>We are able to do this manually in MSAccess. I get field format errors on Job,Status,AR_Customer fields. Apparently these fields have a marker to indicate actual field size. The remote view shows char 10 for Job & AR_Customer. Status indicates char 11.
>
>This is our fourth application for a client who relied heavily on Access/Excel.
A stab in the dark: once upon a time, Turbo Pascal had this habit of prefixing strings on disk with a length byte. So, "good morning" would actually be stored as chr(12)+"good morning". You may try to send those fields as
chr(len(cValue))+cValue