i have this as my connection string
and i'm getting a "'C:\someFile.txt' is not a valid path however C:\someFile.txt will open when executed from run menu so widows does see it. not sure what is going on but if someone can spot something i have wrong in the connection string please let me know.
i've tried it with and without a schema.ini file and got the same error so i don't think that is it
Code:
string someFile = "C:\\someFile.txt";
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + someFile + @";Extended Properties=""text;HDR=YES;FMT=Delimited"""and i'm getting a "'C:\someFile.txt' is not a valid path however C:\someFile.txt will open when executed from run menu so widows does see it. not sure what is going on but if someone can spot something i have wrong in the connection string please let me know.
i've tried it with and without a schema.ini file and got the same error so i don't think that is it