This sample illustrates how to use HTML and JavaScript to read data using the DOM from Internet Explorer using ActiveX.
You can read OL files or XLS files (if Office is installed). You can also read a table from any data file or database server that your installation of SQL Offline supports.
Column 1
Column 2
Column 3
A
B
C
X
Y
Z
INSTRUCTIONS:
Set browser permissions to allow ActiveX (see Security below).
Under Initialize, click SQL Offline (and Excel if Office is installed). If successful, a message box displays the app version number.
Browse for an Offline (OL) file, an Excel (XLSX, XLS, XLSB) file, a data file (for example: ACCDB, SQLITE, or SDF), or a UDL file for a database server.
Click Read Data to load data into the table.
If credentials, a database, or a table name are needed, click the taskbar or Alt-Tab to activate the app.
SECURITY: This sample is meant to illustrate how to use SQL Offline or Excel DOM using ActiveX and requires additional permissions from your browser.
You must enable (Prompt is recommended) Initialize and script ActiveX controls not marked as safe for scripting in Internet Explorer > Internet Options > Security Settings > Custom Level to allow ActiveXObject creation.
In IE10 you must also Include local directory path when uploading files to a server to avoid getting a fakepath error.