destination table, but the values are all NULL. The destination table has the same structure as the source table. It works correctly if I first export the source table to ASCII deilimited and "APPEND FROM" that file. I have read all documentation included with VFP that I can find on the subject. Any ideas will be very much appreciated.
>
>Kent
>roberts@sph.hbocvan.com
Are you sure the structures are the same, including field names? If the destination tables have got long names or so, your conversion routine would have to look like this
select oldfield1 as newfield1, oldfield2 as newfield2... from oldtable into cursor new
select 0
use newtable
appe from (dbf("new"))
...and so on for each table.