>>>>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.

off by 1. too early in the week for this kind of question...