Here is my scenario. I have a data extract that writes a .csv file daily. My desired end result is that I can look back at the history for a specific "customer order," ie. what information existed for order XYZ on April 15? What info existed for that same order on April 16, 17, etc.?

What I'm doing currently (in VB2010) is importing the .csv files into an Access db, then using an OLEDB connection and data reader, bringing a specific day's "table" into a VB data table, which becomes the data source for a datagridview. Putting it into a datagridview is basically not necessary, because I don't view the data there. I search the data table to find the order info I'm looking for, then populate a listview to display it. I enter an order number into a text box then search the data table for that order number. I have a list of all the tables in my access db, so I select a table first, and then supply the order number I'm searching for, etc.

I'm looking for the most efficient way to do this. I don't really want to populate a datagridview, but am not sure how to bypass that step when creating the table, ie.:

Code:
DataGridView1.DataSource = ReaderToTable(datareader)
Is there another way to call this function?

Should I skip the Access piece altogether and just read in the data from the .csv files? Each file has about 40k records.

Any thoughts would be greatly appreciated!

vBryce