Steve;

I would cheat and use Data Junction! :)

Tom


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