Using ADO with a text file

What am I doing wrong?

Wouldn't the steps below create text file with a header of "Name", which I
could use in turn to query on that column?

PS C:\> echo "Name" > data.txt
PS C:\> echo "Test" >> data.txt
PS C:\> gc data.txt
Name
Test
PS C:\> $adOpenStatic = 3
PS C:\> $adLockOptimistic = 3
PS C:\> $adCmdText = 1
PS C:\>
PS C:\> $objConnection = New-Object -comobject ADODB.Connection
PS C:\> $objRecordset = New-Object -comobject ADODB.Recordset
PS C:\>
PS C:\> $objConnection.Open("Provider = Microsoft.Jet.OLEDB.4.0; Data Source
= c:\\; Extended Properties = `"Text;HDR=Ye
s; FMT=Delimited`"")
PS C:\> $objRecordset.Open("Select * from data.txt",
$objConnection,$adOpenStatic,$adLockOptimistic,$adCmdText)
PS C:\> $objRecordset.MoveFirst()
PS C:\>
PS C:\> do {$objRecordset.Fields.Item("Name").Value;
$objRecordset.MoveNext()} until
>> ($objRecordset.EOF -eq $True)
>>
Exception getting "Item": "Exception calling "get_Item" with "1"
argument(s): "Item cannot be found in the collection c
orresponding to the requested name or ordinal.""
At line:1 char:30
+ do {$objRecordset.Fields.Item( <<<< "Name").Value;
$objRecordset.MoveNext()} until
Exception getting "Item": "Exception calling "get_Item" with "1"
argument(s): "Item cannot be found in the collection c
orresponding to the requested name or ordinal.""
At line:1 char:30
+ do {$objRecordset.Fields.Item( <<<< "Name").Value;
$objRecordset.MoveNext()} until
Exception getting "Item": "Exception calling "get_Item" with "1"
argument(s): "Item cannot be found in the collection c
orresponding to the requested name or ordinal.""
At line:1 char:30
+ do {$objRecordset.Fields.Item( <<<< "Name").Value;
$objRecordset.MoveNext()} until
Exception getting "Item": "Exception calling "get_Item" with "1"
argument(s): "Item cannot be found in the collection c
orresponding to the requested name or ordinal.""
At line:1 char:30
+ do {$objRecordset.Fields.Item( <<<< "Name").Value;
$objRecordset.MoveNext()} until

> PS C:\> $objConnection.Open("Provider = Microsoft.Jet.OLEDB.4.0; Data
> Source = c:\\; Extended Properties = `"Text;HDR=Ye
> s; FMT=Delimited`"")

I changed the above to HDR=No, and created a Schema.ini:

PS C:\> gc data.txt
Test
PS C:\> $adOpenStatic = 3
PS C:\> $adLockOptimistic = 3
PS C:\> $adCmdText = 1
PS C:\>
PS C:\> $objConnection = New-Object -comobject ADODB.Connection
PS C:\> $objRecordset = New-Object -comobject ADODB.Recordset
PS C:\> gc Schema.ini
[data.txt]
Col1=Name Text
PS C:\> $objConnection.Open("Provider = Microsoft.Jet.OLEDB.4.0; Data Source
= c:\\; Extended Properties = `"Text;HDR=No
; FMT=Delimited`"")
PS C:\> $objRecordset.Open("Select Name from data.txt",
$objConnection,$adOpenStatic,$adLockOptimistic,$adCmdText)
PS C:\> $objRecordset.MoveFirst()
PS C:\>
PS C:\> do {$objRecordset.Fields.Item("Name").Value;
$objRecordset.MoveNext()} until
>> ($objRecordset.EOF -eq $True)
>> ($objRecordset.EOF -eq $True)
>>


[end]

No more error... No output either.

Any ideas anyone?