First of all, is there a particular reason you are using ADO (which is basically for VB6, aka VB1998) rather than ADO.Net (which is designed for VB.Net)?

There are several articles in the "VB.Net" section of our Database Development FAQs/Tutorials (at the top of the Database Development forum) that explain how to use it.


Next, I may have misunderstood what you are trying to achieve, but it seems to me that you want to load the CSV data and put it into two database tables.

If so, why ask the database to send you data? It would be more efficient to simply add the items instead - as shown in post #3 of the article "Retrieving and Saving Data in Databases" (there is a link to it in the FAQs).

If not, what are you trying to achieve?