Connction string of Spread sheet document

Dear all,

how to write the connection string of XML File which represent a Spread Sheet document

1 answer

If you mean the Open XML office format you can use this.

Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=c:\myFolder\myExcel2007file.xlsx; Extended Properties="Excel
12.0 Xml;HDR=YES";

http://www.connectionstrings.com/ace-oledb-12-0/xlsx-files/