Hi,

I have a two column CSV file embedded in a VB2010 project. I'd like the user to enter some text into a text box which matches with column A of the CSV file - the code should then return the corresponding text in Column B of the cvs file.

I'm a little confused on the best method of dealing with the CSV file..an array? convert to some sort of DB? etc etc.

The only proviso is that as the CSV files change frequently, I need a method that can act 'on the fly' rather than laborious first time job.

Can anyone suggest a good method with code example please?

Thanks
David