Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

In VB parse a text file and then dynamically update an Access Database

Options
  • 24-11-2004 1:16pm
    #1
    Erikeverhard
    Closed Accounts Posts: 6 ✭


    Firstly I have an ascii string 3 lines long in text file format, i want to extract two pieces of data form this string using VB and then send these two items to an Access database. I want to update this database every 10 mins. I was wondering could anyone help?, Thanks, The text file is below, I have bracketed([ ]) what I want extracted from the file.




    14011U34MALE Image:00 offset(gain,phi,motor)=(000 029 021) 11-23-04 [09:40] [0000] 1.469 002 049 128 001 100 2.009 00000021 005 000 2.390 005 10 0 0.000 NO_NOTES_RECORDED -1 -1-000000001 NO_COMPRESSION 00907 iK


Comments

  • Options
    #2
    Hobbes
    Registered Users Posts: 21,264 ✭✭✭✭Hobbes


    Why not show what you have done so far?

    Or is there something in particular you need help with?


  • Options
    #3
    Erikeverhard
    Closed Accounts Posts: 6 ✭Erikeverhard


    Even a link to a similar project, just to see how you would approach this problem.


  • Options
    #4
    jessy
    Registered Users Posts: 950 ✭✭✭jessy


    I know i can be hard when your a beginner and get stuck, but you really need to make an attempt at it.

    to parse the string you might want to look into the split function.
    Theres loads of help in the MSDN library which you should have with VB for updating MS access tables so theres a good place to start. if you get stuck with coding it post your code and you will be guaranteed to get help then.


Advertisement