using System.Data;
 
//in some function
System.Data.Odbc.OdbcConnection conn;
DataTable dt;
System.Data.Odbc.OdbcDataAdapter da;
string connectionString;
string importFolder;
string fileName;
 
importFolder = @"c:\importfile" //or pass it in -this is the folder in which the csv file is in
 
fileName = "csvimport.csv" //or pass it in -this is the csv file to be imported
 
connectionString= @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + importFolder + ";";
conn = new Odbc.OdbcConnection(connectionString)
 
//we only pass it the folder.  The csv file import is in the query which follows
 
da = new System.data.Odbc.OdbcDataAdapter("select * from [" + strFileName + "]", conn);
da.Fill(dt);
 
//Your table is filled and uses the first row of the csv file as the column headings.

imports System.Data;
 
//in some function
Dim conn As System.Data.Odbc.OdbcConnection 
Dim dt As DataTable
Dim da As System.Data.Odbc.OdbcDataAdapter;
Dim connectionString As string
Dim importFolder As string
Dim fileName As string
 
importFolder = "c:\importfile" //or pass it in -this is the folder in which the csv file is in
 
fileName = "csvimport.csv" //or pass it in -this is the csv file to be imported
 
connectionString= "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + importFolder + ";"
conn = new Odbc.OdbcConnection(connectionString)
 
//we only pass it the folder.  The csv file import is in the query which follows
 
da = new System.data.Odbc.OdbcDataAdapter("select * from [" + strFileName + "]", conn);
da.Fill(dt);
 
//Your table is filled and uses the first row of the csv file as the column headings.