ADO Append Query - Text File To Table

[Peter]

I have created some code using ADO to append (insert) the
contents of a pipe (|) delimited datafile into a table.
It does not work and gives me the tablename with a .txt
extension. I create a schema file, it looks good but the
cnn.execute strsql, recs, adexecutenorecords fails.

Does anyone know what the cnn.open 'Provider=... and a
insert command should look like?

It works great with DoCmd.TransferText but the boss wants
ado code.

Thanks, Peter