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