lenchase

lenchase

  • NA
  • 10
  • 0

ado.net connection string for excel

Nov 19 2004 12:28 PM
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

Answers (5)