Using VB to parse a text file

[Roni Sutton]

I have used VB multiple times to copy data from a mainframe session to an Access table using Rumba Object X. I want to do something similar with a delimited text file. Can someone point me in a good direction regarding how to open the file in VB and how to reference the columns and rows? I need to read pieces of a row into various variables and then plan to use an Insert SQL statement to put that data into a table in an Access 2k db. Any ideas would be greatly appreciated.

 

[Roni Sutton]

It is not a fixed length text file and will have to have some serious parsing done before being read into the fields. I don't want to use Access to begin the process because this is going to be an automatic job that runs nightly which I will set up with a batch file to kick off. I have used the import spec a lot and I'll look into using that and creating a timer kickoff from within the db. I wanted to avoid that if I could, though since it's not my db (long story). Thanks for the idea - I will certainly give it a whirl.

 

[Tim K.]

Check the link http://www.utteraccess.com/forums/showflat.php?Cat=&Board=access_2000&Number=110320 out.