Hello everyone! I'm new here. I'm currently working on a project.
The concept is that I created a shell script that will query information, then I will use VB to get the data retrieved by the shell script and put it in a text file. I do not know how to use VB to get the data from the text file and import it to the fields in MS Access.
Hoping for your favorable response
cecille1127
0
Newbie Poster
Recommended Answers
Jump to Postyou want to read a line of text from a text file then import it to access?..
you can use the OPEN function
Dim f as Integer, ReadedLine as string, Content as string f = FreeFile() Open "YourFile.txt" For Input as #f Do While EOF(f) Line …
All 3 Replies
jhai_salvador
48
Junior Poster
you want to read a line of text from a text file then import it to access?..
you can use the OPEN function
Dim f as Integer, ReadedLine as string, Content as string
f = FreeFile()
Open "YourFile.txt" For Input as #f
Do While EOF(f)
Line Input #f, ReadedLine
Content = Content + ReadedLine
Loop
Close #fSomething like that..
Then Content variable will have all readed line from yourText.txt, all you have to do is save it to Access....
Hope this helps you...
cecille1127
0
Newbie Poster
Thank you very much.
I'll work on this code.
=)
jhai_salvador
48
Junior Poster
Your welcome.. :)
PLease mark the thread if your problem is solve...
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.