>hi
>
>i have some old DBF tables from Clipper that i'm trying to copy programmatically, which contain accented characters. however, when i copy the tables, i lose the accented characters.
>
>i've tried a few approaches with the same result:
>1. use, copy structure to, scatter and gather.
>2. select * from table1 into table2.
>3. use, copy to table2.
>
>i need to do this programmatically and can't just use a copy file command. also, CPDBF() on the original table returns 0, and so does the table created.
>
>any help appreciated.
>regards,
>barry

Would field by field copying work using REPLACE NewTable.Field WITH CPCONVERT(850, 1252, OldTable.Field), assuming that the tables originally contain INTERNATIONAL-DOS characters?
--
Jukka Salminen