1

I would like to modify connection strings for excel very much like how SqlConnectionStringBuilder works.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyExcelFile.xlsx;Extended Properties="EXCEL 12.0 XML;HDR=YES";

I tried to use SqlConnectionStringBuilder but it's not working. It says "keyword not supported".

How do I modify this kind of connection string with ease?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Alexander
  • 1,729
  • 3
  • 19
  • 36
  • You might need the [OleDbConnectionStringBuilder](https://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnectionstringbuilder%28v=vs.110%29.aspx) instead – marc_s Jan 15 '16 at 05:58

1 Answers1

0

The easiest place to change this is Excel Connection Manager's ExcelFilePath property.

enter image description here

Source

Community
  • 1
  • 1
Nick Heidke
  • 2,787
  • 2
  • 34
  • 58