We develop applications for BricsCAD/AutoCAD using VB.NET. These apps communicate with MS Access (mdb/accdb) and Excel (xls/xlsx) files. For this we use "ADO.Net" Object Model to Select, Update, Insert, etc... data to the database, connecting through OleDbConnection.
The Provider we use is: "Microsoft.ACE.OLEDB.12.0" installing MS Access Database Engine 2010.
Since few months when MS Office (or Windows) is updated, it corrupts "cpprestsdk.dll" file, which forces us to reinstall MS Access Database Engine 2010.
We tested SQLite a few days ago and it can replace MS Access (mdb/accdb) perfectly. However it would be necessary to continue using ACE.OLEDB.12 & ADO.NET to access Excel.
Communication with Excel worksheets using INTEROP.EXCEL is very slow and does not replace ACE.OLEDB.12 & ADO.NET.
Can anyone give us any suggestions for alternatives to communicate with EXCEL files, not using "Microsoft Access Database Engine 2010" or "Interop.Excel" but allows to Insert, Update and Select data as a database.
Regards,
Tácito Fieker
CADGRAPH