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