Gerry,
I would read through the file using low-level functions (fopen(), fgets(), etc.), and split the line into fields. I would most likely bust the line it into an array, APPEND BLANK, and then do a REPLACE statement.
In VFP3 do you have STRTRAN() and ALINES() functions?
>HDEM|Household demographics|HDEMHHSIZE|Household size|S|HDEMHHSIZE1|One|2|10|1|90|1|1| |
>HDEM|Household demographics|HDEMHHSIZE|Household size|S|HDEMHHSIZE2|Two|2|10|2|90|2|1| |
>
>It's an SDF file that uses '|' as its delimiters. I've copied two lines of it above. -- gww
>
>>Can you post a sample of what the file looks like?
>>
>>>Poop... Thanks. I must have tested the code using VFP 6.
>>>When I enter APPEND FROM (lcIncoming) DELIMITED WITH | at the command line, it ignores the vertical bar and puts everything into one field. So much for my delimiter. Any suggestions?
>>>
>>>Thanks for your help, Steve.
>>>
>>>- GWW
>>>
Steve Gibson