Hello.

I'd like to retrieve a pipe (|) delimited text file into an ADO recordset.

I've attempted to follow the intrsuctions listed he

http://msdn2.microsoft.com/en-us/library/ms974559.aspx

and have it working, aside form the fact that the record is not being parsed
into fields.

According to that Microsoft article (at least as I read it, perhaps
incorrectly), all I needed to do was use:

FMT = Delimited(|)

in the connection string... like this:


stConString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strPathtoTextFile & ";" & _
"Extended Properties=""text;HDR=YES;FMT=Delimited(|)""


With that, I'm getting the proper data in my ADO recordset (which I in turn
intend to use as a PivotCache, but I know how to do that), but it's not
delimited...

It's just one big a|b|c|d|e single field record.

Can someone help me with that?

Thanks.