Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Add records to a DB table from ASCII comma delim file?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00339702
Message ID:
00339784
Vues:
21
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform