pull info from a csv file using C#

[katy07]

Hello! I'm hoping someone might be able to help me. I am writing a program that pulls info from a csv file and imports into an oracle table. Right now all I'm trying to do is connect to the csv file (it's on my computer) so that I can pull the data out. But no matter what I try I get an error. Can u please tell me what I'm doing wrong? Everything commented out is code I've tried and hasn't worked.

private static void PullRecords (string csvFile)
{
//string connString = @"Driver={Micro soft Text Driver (*.txt;*.csv)}; Dbq="+csvFile+" ;Extensions=csv ;";
//string connString = @"Driver={Micro soft Text Driver (*.txt; *.csv)};Dbq="+c svFile+";Extens ions=asc,csv,ta b,txt;";
//string connString = @"Provider=SQLO LEDB; Data Source=C:\new_t ickets.csv;";

string selectString;

System.Data.Odb c.OdbcConnectio n conn;
//System.Data.Ole Db.OleDbConnect ion conn;
System.Data.Odb c.OdbcDataAdapt er adapt;
//System.Data.Ole Db.OleDbDataAda pter adapt;

// Create connection to csv file
conn = new System.Data.Odb c.OdbcConnectio n(connString.Tr im());
//conn = new System.Data.Ole Db.OleDbConnect ion(connString. Trim());

// Open the connection
conn.Open();

...code...

// Close connection to csv file
conn.Close();
}

[katy07]

Nevermind, I figured it out. I guess all it took was asking for me to find my error...

Hello! I'm hoping someone might be able to help me. I am writing a program that pulls info from a csv file and imports into an oracle table. Right now all I'm trying to do is connect to the csv file (it's on my computer) so that I can pull the data out. But no matter what I try I get an error. Can u please tell me what I'm doing wrong? Everything commented out is code I've tried and hasn't worked.

private static void PullRecords (string csvFile)
{
//string connString = @"Driver={Micro soft Text Driver (*.txt;*.csv)}; Dbq="+csvFile+" ;Extensions=csv ;";
//string connString = @"Driver={Micro soft Text Driver (*.txt; *.csv)};Dbq="+c svFile+";Extens ions=asc,csv,ta b,txt;";
//string connString = @"Provider=SQLO LEDB; Data Source=C:\new_t ickets.csv;";

string selectString;

System.Data.Odb c.OdbcConnectio n conn;
//System.Data.Ole Db.OleDbConnect ion conn;
System.Data.Odb c.OdbcDataAdapt er adapt;
//System.Data.Ole Db.OleDbDataAda pter adapt;

// Create connection to csv file
conn = new System.Data.Odb c.OdbcConnectio n(connString.Tr im());
//conn = new System.Data.Ole Db.OleDbConnect ion(connString. Trim());

// Open the connection
conn.Open();

...code...

// Close connection to csv file
conn.Close();
}