>>>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?
Your right the

Maximum # of fields per record 255

So I hope that normalization will occur sometime. If the table to be created is not normalized then
he has a problem.