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 log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions