Information générale
Catégorie:
Codage, syntaxe et commandes
>>>I have a table with about 40 fields and I am wanting to write a program to import a text file into this table. The way I envision doing this is with 40 fgets() into 40 variables and then do an insert into with the 40 variables. Is the best way to accomplish this task?
>>
>>I don't think so...I did it that way years ago, but now I use a dbf structure with Append From flatfile Type SDF.
>
>More on this...here's the idea I used:
>
>1) Append all lines into a table T1
>2) Create T2, with 40 fields or whatever
>3) Create AFIELDS(A1,'T2')
>4) Go through loop, using Replace (A1,ncounter,1) with T1 value (SKIP each time) for each grouping of 40 or whatever T1 records, 1 to ncounter. Do APPEND BLANK each time for T2.
>5) Reformat any non-char fields afterwards. If you do this regularly, create a program to do it...
I do the same way but isn't it "DELIMITED" or "WITH dilimiter" instead of "SDF"?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement