Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
There is no native way to do it because by default the row and the record represent the string in the flat file, and different records mirror different strings. So you need to write a custom code to transpose the string. YOu may use:
fopen() and fgets(), or
filetostr, and strip out strings as needed, or
append into temporary cursor, scan and extract fields/record portion and then insert them into table as needed.
>That drops all information per line into each field.
>
>Example of what I need.
>
>ABCDEFGHIJ,1234567,78910
>
>Table is Xtable with 1 field named data.
>1st record - data = ABCDEFGHIJ
>2nd record - data = 1234567
>3rd record - data = 78910
>
>
>Using append from (file) sdf gives me this
>1st record - data = ABCDEFGHIJ,1234567,78910
>
>If I use append from (file) deli with ,
>It inserts into the next field of the same record instead of the going to the next record.
Précédent
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