delimited text and ADO

This worked for me...

{Change that HDR parameter to YES if you have a header row}
ADOConnection1.ConnectionString :=
'Provider=Microsoft.Jet.OLEDB.4.0;' +
'Data Source="c:\"; ' +
'Extended Properties="text;HDR=NO;FMT=Delimited"';
ADOConnection1.Open;
ADODataSet1.LockType := ltReadOnly;
ADODataSet1.CommandType := cmdText;
ADODataSet1.CommandText := 'select * from CSVText.csv"';
ADODataSet1.Open;

Opend right up and showed in a DBGrid...