Help In Using ADO.NET To Read From Text Files(CSV Delimited)

Hello there

I have written a small code that is used to read records from a txt or a csv file, but when i try to read from a txt or csv file which is in unicode, i get the following error

No value given for one or more required parameters........this error is recieved on the following line

dtadpt.Fill(DataSet.Tables("table2"))



The code for reading from a file is as follows

Dim dtrow As DataRow

Dim cmdtxt, file, path

Dim dtadpt As New System.Data.OleDb.OleDbDataAdapter

Dim Command As System.Data.OleDb.OleDbCommand

Dim Conn As System.Data.OleDb.OleDbConnection

file = 'name of the file'

path = 'path of file'

Conn = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source=" & path & ";" & "Extended Properties=""text;HDR=YES;FMT=Delimited""")

For Each dtrow In DataSet.Tables("table1").Rows

Dim id



id = dtrow.Item("id")

cmdtxt = "Select * from " & file & " where id = " & id



Command = New System.Data.OleDb.OleDbCommand(cmdtxt, Conn)

dtadpt.SelectCommand = Command

Next

DataSet.Tables.Add("table2")

dtadpt.Fill(DataSet.Tables("table2"))

this code works if i choose a csv or txtfile which is in ANSI format. But i want to read from a unicode file because i have some information in that unicode format that i want to store

any idea how this can be possible



thanks and best regards

Saad