>>I am currently trying to append a text file which contains more than 300+ fields. What is the best solution to append a text file without losing any of the fields??
>
>In addition to what Bret said, you can also dump the flat file into one table to begin with, mapping a number of the text fields into one table field. Then split the table fields up afterward into 2 or more tables using SQL. Often you'll want to create child tables anyway...

doesn't vfp still have the 254 fields/table limit?