Max,

Having too many fields is not a problem. You need to add the word "character" to the command if there are no qoute marks around the fields.

append from yourfile.dat type delimited with character "|"

>Good thought! The table I created had 51 fields and the .dat file had 50 fields. There aren't any field names in the .dat file, just the data separated with the '|' symbol. I removed the extra field and checked the field sizes and thay appear to be large enough. It's still not bringing in all the fields though. Is there a way to bring in the fields one by one without it adding double, triple and more rows with blanks? It would be really hard to have to create 50 separated tables and do a REPLACE ALL table.field with table2.field.
>Thank you!
>Also thank you Wayne, Nadya, Thomas and Sergey!
>Max
>
>
>>Do you have field names as the first line of data in this file? Then try >this:
>
>>APPEND FROM yourfile.dat TYPE CSV
>
>>Did you also create a table with your 51 fields (appropriately sized) in it >first?
>>Fred
>>Microsoft Visual FoxPro MVP
>>Join us at El Zorro:
>>www.elzorro.org