General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only