User107

User107

  • NA
  • 28
  • 17.7k

oledb excel connection instead of Openoffice calc connection

Sep 28 2016 1:52 AM
In my web application i need to import Openoffice calc data into sql server database i searched in google but i didn't get i found one oledb connection instead of that how can i take openoffice calc data connection.<br /><br /><div>This is the oledb connction:</div><div>&nbsp;</div><div>&nbsp;</div><div><pre><code>string excelConnectionString =<br />string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 8.0", path);<br /><br /><br /><p>and how can i get open office calc to connection.</p> <p>can anyone tell to me how can i do this</p> <p>Thank you</p><br /></code></pre>&nbsp;</div>

Answers (3)