Text Delimiters

[Gary.Lowe]

Hi All

I am using ADO to open a text file into a recordset

    Dim cn As ADODB.Connection
    Dim rs As ADODB.Recordset

    Set cn = New ADODB.Connection
    Set rs = New ADODB.Recordset
    
    'open connection to folder that contains the file
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\;Extended Properties=Text;"
    
    'open the file
    rs.Open "select * from test.txt", cn

This works fine on a file where the delimiter is a comma i.e.
0,23,"Hello"

But if the dilimiter is a semi-colon it doesn't work i.e.
0:23:"Hello"

Does anyone know if you can specify the delimiter in the connection or recordset object

Thanks

[SteveFlitIII]

Gary,

If You use the ODBC text driver I think you can specify the delimeter in a file which must be called schema.ini and this file has to be located in the same directory as the source text file.
I'll try and dig out some code.
Ta
SteveFlit
Also at ANKER