Hi,

    Can you help me to what provider should I use for using ".ods" file.

For e.g  

".xls" = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txtExcelPath.Text
+ ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";

 

".xlsx" = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
txtExcelPath.Text + ";Extended Properties=\"Excel 12.0
Xml;HDR=Yes;IMEX=1\"";

 

 

Thank You in Advance

Anik Ghosh

 <http://pdsinfotech.com/> header-menu

PDS Infotech (P) Ltd.
20 Old Court House Street
2nd Floor, Kolkata 700001
Tel. : +91-33-22623535, 64596006
Fax : +91-33-22488451



 

Reply via email to