>In that case, create a temporary cursor, append data into cursor and scan through changing your data and Insert each record into the target table.
>
>>Mods would most likely be ignoring certain fields, possibly changing the format of a field, etc.
>>
>>Pete
>>
>>
>>>Append From first springs to mind. But you say 'modifications' - depending on those mods, there can be many ways of doing it. Append to a cursor and then Insert into the table, read low-level and Insert into table, etc.
>>>
>>>>I need to add records to a database table (with some modifications) from an ASCII comma
>>>>delimited file created by another application. How do you do this?
>>>>
>>>>Thanks
Another option, if you are using VFP6 is filetostr(). Then just do the build from the variable. This way you can make mods on the fly.
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com