Hello there,
I am in troubles again with VB.
I am trying to load a *.csv file in an ADO recordset and I found all the necessary syntax on the web but my code is still not working. Is it because I need to specify a schema.ini; the data is separated by commas and I would have thaught there was no need for such a schema.ini file.
The code is very simple:

Public Function Read_Text_File() As ADODB.Recordset

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.Open 'DRIVER={Microsoft Text Driver (*.txt; *.csv)};' & _
'Dbq=C:\marco;' & _

rs.Open 'SELECT * FROM Smith.txt, conn, adOpenStatic, adLockReadOnly, adCmdText'
Set Read_Text_File = rs
Set rs = Nothing
Set conn = Nothing

End Function

Thanks a lot to everybody,