Dataset Sql Statementprob
DataSet csv=MyCSv2Dataset("test.csv");
DataTable CSVTable = csv.Tables["CSV"];
CSVTable.TableName = "CSVTable";
string insert = "INSERT INTO TBL_SecurityName ( SecurityName )"
+ " SELECT CSVTable.[Security Name]"
+ " FROM CSVTable"
+ " LEFT JOIN TBL_SecurityName ON " + "CSVTable.[Security Name]=TBL_SecurityName.SecurityName "
+ "GROUP BY TBL_SecurityName.SecurityName, " + "CSVTable.[Security Name]"
+" HAVING (((TBL_SecurityName.SecurityName) Is Null))";
aCmd = new OleDbCommand(insert, Myconnection);
aCmd.ExecuteNonQuery();
But the jet driver does not find CSV !! Thats clear since it s not a table but my own Dataset.
Any idea how to solve this for this SQL Statement

