>to convert dbf to xls is simple
>use xxx.dbf
>copy to zzz type xls
>
>but to convert txt file into xls.... how??????
There are several possibilities, depending on the format of the data. You may want to look at my article on text manipulation, to get some ideas:
http://www.levelextreme.com/Magazine/August2003/Page20.aspIn this case, if the file is comma-delimited, I think you should convert it to DBF first, with APPEND FROM or IMPORT.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)