I am trying to create a set of routines for converting tables from a FP DOS 2.6 application to VFP 5.0. The source tables are "free" and the destination tables are configured within a database. Beginning with the most simple part of the problem, a lookup table with 2 columns and 7 rows and using APPEND FROM (VFP 5.0 documentation implies that INSERT INTO works with single row inserts only -- is that true?), I end up with 7 rows in the 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