Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2005
    Posts
    144

    Smile Unanswered: importing/reading specific data from a text file

    Hello All,

    I can really use an expert advice from the gurus here.

    At work I have a program that allows me to save a config using a browser that will let me copy the output in a text and or html file. In order to launch a config window you have to click a link in the browser which it turn opens a separate browser popup window.

    output data has lots of info but I am looking for info that starts with the word show with greater than sign in front of it....

    for example:
    >SHOW FAN
    FAN HEALTH:
    FAN1: OK
    FAN2: OK
    VERSION: 5.3

    > SHOW LIGHTS
    #LIGHTS ALL GREEN
    etc etc etc

    I have tried in Access, Excel and visual basic but no luck.

    Data is mix so I understand it is going to be difficult to read/import.

    what I would like to have is an interface where using txt file I can either view it immediately or import it and then view it after it is saved.
    I would prefer access to do it but other programs are ok as well.

    Does anyone have any suggestions and or samples I can get started with?

    I would really appreciate it.

    Thanks,

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,422
    Provided Answers: 7
    This Should get think down the right line

    http://www.homeandlearn.org/open_a_t...le_in_vba.html
    Last edited by myle; 10-05-16 at 17:42. Reason: spelling
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Jul 2005
    Posts
    144
    Hello Myle,
    Thanks for your quick response!

    I have tried creating an excel file using the example from the website and ran into an error. if I click on debug it highlights the first activecell line in yellow.

    I am going to upload error screen shot here but I am not sure I should do that as this forum is for access only? or I can copy paste this in the excel forum?

    also since I absolutely love access is there anyway to just pluck out the data that I am looking for using access?


    Quote Originally Posted by myle View Post
    This Should get think down the right line

    http://www.homeandlearn.org/open_a_t...le_in_vba.html
    Attached Thumbnails Attached Thumbnails Excelerror.JPG  

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,422
    Provided Answers: 7
    Msaccess doent not know what activecell is

    if you debug.print linefromfile you see something

    then base on you data split by the :

    now LineItems will show

    LineItems(0)= should be the Feildname

    LineItems(1) = should be the Value
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •