Connction string of Spread sheet document

Dear all,

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

0
edit delete
are you sure?
asked niz naz

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/

0
edit delete
are you sure?
answered Richard Honnenheim

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions