Query from CSV file help...(urgent)

[jerry_hokh]

Hi guys,
does any body know how to query an csv file in vb.net? Like, select * from a.csv where ...=... , the thing is, my csv dosent have a column name, there is only data.

it wuold be appreciated if any one can help me

thanks

Jerry.

 

[jmcilhinney]

I don't think that you can perform queries on specific columns if there are no column headers but you can certainly do a "SELECT *". It's just straight ADO.NET with some very minor adjustments to the connection string and the SQL code. You can get the details at www.connectionstrings.com. It's possible that you can refer to unnamed columns by "column1" or something like that but I've never seen anything written that specifically says so.