I wrote the following code:
fileName variable has a value c:\temp\meter.csv
In the debug mode, I am able to view that a correct filename value got assgined to the variable fileName.
But it is throwing an execpetion:
+ $exception {"'C:\\temp\\meter.csv' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."} System.Exception {System.Data.OleDb.OleDbException}
private static DataSet GetDSFromCsv() {
string fileName = Global.CsvFile; DataSet ds = new DataSet();
if (File.Exists(fileName)) { ds.DataSetName = "Reads"; using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source= " + fileName + ";Extended Properties=\"Text;HDR=YES;FMT=Delimited\"")) { try { using (OleDbCommand command = new OleDbCommand("select * from [" + fileName + "] ", conn)) { using (OleDbDataAdapter adapter = new OleDbDataAdapter(command)) { try { adapter.Fill(ds); } catch (Exception ex1) { Console.WriteLine(ex1.ToString()); } } } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } } } return ds; }
Question:
Am I missing something?
Thanks