Anyone know how to use ADO to read a csv file?

My requirements are:

Must use ADO
Must use a connection string (Cannot use a DSN)

Thanks for the help