VB Forum / Database Access / January 2007

Given a CSV file in C:\DATA\ALL.csv that starts as follows:
"Object Short Text","Object Level","Created By","Last Modified By","Object
Text","Object Number","Created On","Last Modified On","Object
Identifier","UCorUCS","Object Heading","Absolute Number","Created Thru"
,1,"xyz","abc","Data",1,"8/27/2001","1/16/2006","XT-EOU-ACTMGR-88",,"Introduction",88,"Manual Input"
,2,"xyz","abc",,"1.1","8/27/2001","9/11/2002","XT-EOU-ACTMGR-89",,"Actors",89,"Manual Input"

The code...
       Dim rs As ADODB.Recordset
       rs = New ADODB.Recordset
       Dim conn As ADODB.Connection
       conn = New ADODB.Connection
       Dim DirectoryName = "C:\DATA\"
       conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
DirectoryName & ";Extended Properties=""text;HDR=YES;FMT=CSVDelimited""")
       rs.Open("select [Object Identifier] from [ALL.csv]", conn,
ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly)

Gives the **classic** error "No value given for one or more required
parameters"

The SQL statement:
       rs.Open("select * from [ALL.csv]", conn,
ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly)\\

Returns all 22736 rows the top two of which are shown above.

I'm using Visual Studio 2005 (8.0.50727.42) with .NET framework 2.0.50727
and Visual Basic 2005.

This same code worked under Visual Basic 6.

What could be causing the problem with the failing SQL select statement?  
The select all fields version shows that the file is being read in its
entirety (should not be a permission problem and the file is available.)  I
do get the idea that it does not like the column names.  When the entire
table is read with all fields the 0th record is the first data record.  I
hope I'm just missing something very simple.

Thanks.