Reading a Text File

[jplum]

Is there a way to read a text file in field by field?

I have a text file with multiple records, each record is made up of multiple fields which have quotes around them and are separated by commas.

One thought is to read the whole record in and then search for the commas to read the fields in individually, I just thought there should be an easier way.

Thanks,
Jennifer

 

[krisbrixon]

I thought I heard one time that ADO will read text files, if so maybe it can read the comma delimited for you.

This web page might get you started:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvsm01/html/gs0111.asp