Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting data from a text file
Message
From
18/03/2002 07:04:23
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
18/03/2002 07:00:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00634018
Message ID:
00634019
Views:
21
>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)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform