When you use the built-in Rapise Global Spreadsheet object on a computer that has a 64-bit version of Microsoft Excel 2013 (or later) installed you may get an error similar to:
Runtime error 3706, provider cannot be found. it may not be properly installed
As described in several Microsoft KB articles, this error will be because you don't have the correct 64-bit OLEDB Jet drivers installed.
A simple workaround that doesn't involve installing any software is to simply use Excel files in the older 'xls' format instead of 'xlsx'. It
uses a different approach for opening and works on both 32-bit and 64-bit versions of Office / Excel.
So the simplest
workaround is to open a data file, save it in the 2003-compatible workbook format and
change the path in the .js script from "
The second approach which actually fixes the underlying issue is to install the two missing Microsoft libraries:
After installing both libraries, Rapise should then be able to open the .XLSX format files correctly.
- The Microsoft Access Database Engine 2010 Redistributable (x64)
(press "Download" and then tick checkbox next to AccessDatabaseEngine_x64.exe and then install it)
- The 2007 Office System Driver: Data Connectivity Components
Just download and install.