C# issue with oledb connection string for excel

Question

I receive a string like "c:\test\abc.xlsx" which indicates me the excel path. I have to depend on what i receive and cannot hard code it. Now what how should i make sure the the single "\" is escaped and it becomes "\"

string **PATH** = "c:\test\abc.xlsx"
string conn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=**PATH**;Extended Properties=Excel 12.0;";

Sheridan · Accepted Answer · 2014-11-10 12:51:18Z

1

The single "\" doesn't appear to be escaped properly.

Try: string path = @"c:\test\abc.xlsx";

The leading @ sign will escape it properly for you

edited Nov 10, 2014 at 12:51

Sheridan

70.1k24 gold badges151 silver badges193 bronze badges

answered Jun 4, 2013 at 11:39

baxter

422 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DonBoitnott · Accepted Answer · 2013-06-04 11:46:59Z

1

Should be simple:

String thePath = "c:\\test\\abc.xlsx"
String conn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + thePath + ";Extended Properties=Excel 12.0;";

edited Jun 4, 2013 at 11:46

answered Jun 4, 2013 at 11:31

DonBoitnott

11.1k7 gold badges53 silver badges70 bronze badges

1 Comment

Bhaskar Mishra Over a year ago

Hey I am new to C# ; but if you see i should replace the single "\" to "\\" for the path, else the code gives an error, how do i do it.

Collectives™ on Stack Overflow

C# issue with oledb connection string for excel

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related