ado.net connection string for excel
Hi,
I got this to work in vb.net
but I can't seem to get the right syntax for the Extended Properties portion in C#.
Any help is appreciated.
[vb.net]
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\AAAProjects\Vb.net\ExcelDataSourc" & _
"e\Members.xls;Extended Properties=""Excel 8.0"";"
I tried
";Extended Properties='Excel 8.0'";
"Extended Properties=\"Excel 8.0\";";
Thanks
Len