oledb excel connection instead of Openoffice calc connection

User107

10y1.7k.NET

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.

This is the oledb connction:

string excelConnectionString =
string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 8.0", path);


and how can i get open office calc to connection.
  can anyone tell to me how can i do this
  Thank you

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
I hope you are having .ods file.
If yes, then may be you should try the link i had suggested.
The link you had given is referring to .xls files, which are entirely different than .ods files.
Even if you can open .xls file in OpenOffice (or may be .ods file MS Excel, i never tried) it does not mean their internal binary structure is same. In fact it is almost always different because they are the products from two different vendors!
Connection string rely solely on their binary structure.
User10710y ago
Hi Thank you for resopnding, I am seeing this link
http://www.c-sharpcorner.com/uploadfile/99bb20/import-excel-data-to-sql-server-in-asp-net/
In the above using oledb connections to import excel data to database instead of that i am following that link and i converting for my requirment i need to import openoffice calc to sql server data base. can you please check this link and say me is it possible to do my requirment or not. i searched all codes but i am not getting any thing can you please help me to do this.
Thank you
Nitin Sontakke10y ago
Have tried this?
https://www.connectionstrings.com/openoffice-spreadsheet/