mre531s
asked on
ADODB CONNECTION EXTENDED PROPERTIES FOR DELIMITED FILES
I can use the following code to open a comma delimited text file. I am trying to find information on the extended properties string to allow a different delimiter. Example Ç or | or some other character depending on the text file.
Set cnnText = New ADODB.Connection
cnnText.Open "Provider=Microsoft.Jet.OL EDB.4.0;" & _
"Data Source=" & strFilePath & ";" & _
"Extended Properties=""text;HDR=No;F MT=Delimit ed;"";"
Set cnnText = New ADODB.Connection
cnnText.Open "Provider=Microsoft.Jet.OL
"Data Source=" & strFilePath & ";" & _
"Extended Properties=""text;HDR=No;F
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.