S
Simple Simon
I'm trying to read a CSV file that happens to have some spaces in
it...(Land - Lot.csv) For some reason, the SQL statement can't find
the file...ne1?
// CSV file connection
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\Temp;Extended Properties=\"Text;HDR=YES;FTM=Delimited\"";
OleDbConnection oleCon = new OleDbConnection(strCon);
oleCon.Open();
strSQL = "SELECT * FROM Land - Lot.csv";
OleDbDataAdapter daRead = new OleDbDataAdapter(strSQL, oleCon);
TIA,
~Gordon
it...(Land - Lot.csv) For some reason, the SQL statement can't find
the file...ne1?
// CSV file connection
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\Temp;Extended Properties=\"Text;HDR=YES;FTM=Delimited\"";
OleDbConnection oleCon = new OleDbConnection(strCon);
oleCon.Open();
strSQL = "SELECT * FROM Land - Lot.csv";
OleDbDataAdapter daRead = new OleDbDataAdapter(strSQL, oleCon);
TIA,
~Gordon