Yes, you just need a text driver, for example the Jet 4 driver which is usually used to connect to Access can also be used for text files. You need a connection string like this:
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\your_path\;Extended Properties=""text;HDR=No;FMT=Delimited"""
'Note that the Data Source is the directory that contains the csv file.
'The name of the actual file goes in the SQL statement, e.g.
oRS.Open "Select * From MyFile.csv", oConn, adOpenStatic, adLockReadOnly, adCmdText