>Hi, I need to import a text file in the following format:
>
>"12";"....+....1";"Memo Text"
>
>I tried to use
>
>APPEND FROM test.txt DELIMITED WITH CHARACTER ";"
>
>But the memo field is not filled. Is there any way to do this without using Low Level file manipulation?
>
>Regards,
With an intermediate cursor you could do it (provided memo text would fit). ie:
select *, space(254) as m1 myTable where .f. into cursor crsTemp nofilter
use dbf('crsTemp') in 0 again alias crsRW
use in 'crsTemp'
select crsRW
APPEND FROM test.txt DELIMITED WITH CHARACTER ";"
replace all myMemo with m1
select myTable
append from dbf('crsRW')
PS:Not tested.
Cetin