text file I/O in VB

I need VB to open a text file containing thousands of (approx 1,600) email messages and read the email addresses and names and write them to an access db table, what are the best functions to use in this situation....how best approach this problem?
SeaghanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

VbmasterCommented:
It depends on how the data is stored in the file. The easiest solution would probably be to open the file and read line by line using the Line Input statement.. something like this..

Dim Filenr as Integer
Dim sValue as String

Filenr = FreeFile
Open filename For Input As #Filenr
Do Until EOF(Filenr)
  Line Input #Filenr, sValue
Loop
Close #Filenr
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
eab111098Commented:
How is this text file structured. In other words, how do you decipher between an email address and alias names?

Ed.
0
kplonkCommented:
you could look for a "www" string in the file, that would be a good place to start. then reed to the next chr(32) or space that you give you the email address
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.