You're right about the DELETE, didn't figure out at start why you included it. In the end, this was really the solution i used. I created a table with all char fields, appended including field names, then deleted first row. Afterwards moving data from char to respective types was a breeze.
Thanks for your help
Jaime
>Sure it does. That's why I added DELETE command to my code. You can also use FOR clause to filter out the first row.
>
>>That's exactly the first thing i tried, but it imports the field names from the first row as well in this case...I'll have to strip them before importing then...
>>Jaime
>>
>>>Try
>>>APPEND FROM temp.txt DELIMITED WITH CHARACTER "," WITH ""
>>>GO TOP
>>>DELETE
>>>
Why do programs stop working correctly as soon as you leave the Fox?