Sure. You can just open and read it as a text file. Either by using the built-in Open and Line Input # statements, or by using the FileSystemObject model. There are samples in the VB Articles area that show how to do this.
Extracting the particular data that you want may be very simple, or slightly more complex, depending on the answer to one important question...
Is it possible that any of the data fields can contain a comma?
If not, then you can just use the Split() function to split up the record into and array based on the commas. However, if there may also be commas in the data, that won't work and you will have to do a bit more work.
this is a line from the file i need to read.
2007-May-22 07:29:55 AM,,VIN:00000000000000000
CSN:0000000 BCM_PN:00000000 IPC_PN:00000000 RADIO_PN:00000000 HVAC_PN:00000000 HUD_PN:******** XXXXX-967 2008 AUTO_HVAC FOG_LAMP_SW GPS_PRESENT TELESCOPING_STEER DIC_PRESENT REAR_DVD,
FAILED ,PASS,PASS,*NOT DONE*,*NOT DONE*,PASS,PASS,PASS,PASS,PASS,PASS,PASS,PASS,PASS ,PASS,PASS,PASS,PASS,PASS,PASS,PASS,PASS,*NOT DONE*,PASS,PASS,PASS,PASS,PASS,PASS,PASS,PASS,PASS ,PASS,*NOT DONE*,PASS,*NOT DONE*,PASS,PASS,PASS,PASS,PASS,*NOT DONE*,PASS,PASS,*FAIL*,PASS,PASS,PASS,PASS,PASS,PA SS,PASS,PASS,PASS,PASS,PASS,PASS,PASS,PASS,PASS,PA SS,PASS,PASS,PASS,PASS,PASS,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,PASS,PASS,PASS,PASS,PASS,PASS,PASS,*NOT DONE*,PASS,*NOT DONE*,PASS,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,PASS,PASS,PASS,PASS,*NOT DONE*,PASS,PASS,*NOT DONE*,PASS,PASS,PASS,PASS,PASS,PASS,*NOT DONE*,*NOT DONE*,PASS,PASS,PASS,PASS,PASS,*NOT DONE*,PASS,PASS,PASS,PASS,PASS,PASS,*NOT DONE*,PASS,*NOT DONE*,PASS,PASS,PASS,*NOT DONE*,*NOT DONE*,PASS,PASSED,PASSED,PASSED,PASSED,PASSED,PASS ED,PASSED,PASSED,PASSED,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,PASSED,PASSED,PASSED,PASSED,PASSED,PASSED,PA SSED,PASSED,PASSED,PASSED,PASSED,PASSED,PASSED,PAS SED,PASSED,PASSED,*NOT DONE*,*NOT DONE*,*NOT DONE*,PASSED,PASSED,PASSED,PASSED,PASSED,PASSED,PA SSED,PASSED,PASSED,PASSED,PASSED,PASSED,PASSED,PAS SED,PASSED,PASSED,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,PASSED,PASSED,PASSED,PASSED,PASSED,PASSED,PA SSED,PASSED,PASSED,PASSED,PASSED,PASSED,PASSED,PAS SED,PASSED,PASSED,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,*NOT DONE*,PASSED,PASSED
the bold underlined fields is all i really need from the file.