ado.net connection string for excel

lenchase

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

lenchase22y ago
Hi, The example is good but my problem is converting it to c# the connectionstring I showed in the first post works in vb but I can't seem to convert so than it will work in c#. Len
0
lenchase22y ago
I didn't see your reference to www.connectiontrings.com until I posted my reply thanks again. Len
0
lenchase22y ago
Thanks I will try it. Do you have a source of where you got the detailed driver Info? If so can you share it I have been able to find anything with that amount of detail. Len
0
Andrzej Wegierski22y ago
May be, You have extra semicolon in the end of Extended properties. I can't correct my last message because of an error in forum - it's impossible to edit message with HTML inside.
0
Andrzej Wegierski22y ago
An example from http://www.connectionstrings.com Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" "HDR=Yes;" indicates that the first row contains columnnames, not data "IMEX=1;" tells the driver to always read "intermixed" data columns as text TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
0