Dear VB Elite,

I have this CSV file saved as juvrec.txt from a database from this old DOS program DataEase...[hell]... I need to figure out a way to get a VB program to read the CSV and export it to a database in SQL Server. Any help/starter suggestions would be excellent because I am clueless as where to begin.

EX:
The first line of the text file is column names for the table. The second and so on are the actual fields.

The second line is "00001","ABBOTT","GEORGE","RYAN","",,W,M,9/9/1979,"","MI","1290 PARK RD"

How would I get the program to take the strings and put it in a desired column in a table in SQL? I hope this post makes sense because I'm clueless and lost. Thank you for even reading this.