Using odbc to connect to an open office

Question

I wanted to know if there is a way to connect to open office calc (Same as MS Excel) using the odbc and run sql commands. I can do this with Excel and odbc in C #. This can be done in C # using odbc and open office calc.

Answer 1

provider=Microsoft.ACE.oledb.12.0;datasource=path of db 

try this connection string