Problem inserting variable in conn string

George Laing

Hi All,
I seem to be having difficulty inserting a variable in the middle of my connection string. Seems it should be easy enough but I have tried many different ways. I am uploading an excel sheet and at this point have the path hard coded. I want to use a variable for the path. Here is the string.

string ExcelconnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= D:\Debug\Draft company_Oilco9.xls;Extended Properties=""Excel 8.0;HDR=YES;""";

Here is what I tried that didn't work

string ExcelconnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" text";Extended Properties=""Excel 8.0;HDR=YES;""";

Any help is appreciated

5 Replies

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

Alan18y ago
Accepted answer
You also need an @ preceding the final string because of the use of the doubled double-quotes which isn't allowed in a 'normal' string:

string ExcelconnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + text + @";Extended Properties=""Excel 8.0;HDR=YES;""";
Alan18y ago
If you've started a thread, then there's an option to mark a reply as "Accepted Answer" so anyone with a similar problem in future knows how to solve it.
George Laing18y ago
That did it thank you very much. Is there a proper way to close the thread and award points for the solution etc?
George Laing18y ago
Hi,

I tried your line and I get basically the same problem as I had with the line I tried. the part of the string below is underlined and I ger "; expected". As I say it seems to be trickier than expected.

"Excel 8.0;HDR=YES;"""
Ryan Alford18y ago
here you go...

string ExcelconnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + text + ";Extended Properties=""Excel 8.0;HDR=YES;""";