>Hi
>
>Im trying to get data from outlook into a dBase file using VBA, as i am having trouble with this im thinking of another way to do it.
>
>I can get the data and put it into a text file, but how would i read a text file in visual foxpro and extract the relevant data i need to put into a table?
>
>Thanks
>Nelly
That depends a lot on the format of the textfile. In general, you have several options.
See:
COPY FROM ... DELIMITED
IMPORT
FileToStr() and alines() (limited to 65000 lines)
fopen(), fgets(), fclose()
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)