error "No such interface supported" when openening a connection to a text file
- From: philippe_cloquet@xxxxxxxxxxx
- Date: 16 May 2006 06:51:37 -0700
Help !!!!!!
I'm trying to open a text file with an ADO connection.
This is the code :
Dim objConn As New ADODB.Connection
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strPathtoTextFile & ";" & _
"Extended Properties=""text;HDR=No;FMT=Delimited"""
strPathtoTextFile is the path where the text file is located eg d:\
in the same directory i have also a Schema.ini and look like this :
[Test.txt]
Format=FixedLength
Col1=Name Text Width 20
Col2=LastName Text Width 15
when I try to open the connection I get this error :
-2147467262 : No such interface supported
Can somebody help me ?
.
- Prev by Date: lock_timeout question
- Next by Date: adOpenForwardOnly
- Previous by thread: lock_timeout question
- Next by thread: adOpenForwardOnly
- Index(es):