Database Interface You do not need to have Excel installed on the same computer as IWS; IWS can directly read from and write to an existing XLS/XLSX file. However, you do need to use Excel to create the initial file — either a blank spreadsheet for new data or a populated spreadsheet for reference data. Once you've created the file, you can move it to any location and establish a connection to it there. Note: This procedure was last tested using Microsoft Excel 2007 (12.0.6331.5000). To establish a connection between your IWS project and your XLS/XLSX file: 1. In the Database Configuration property sheet , click the Browse button ( … ). The Data Link Properties property sheet is displayed:
Selecting the OLE DB Provider 2. Select the appropriate OLE DB Provider for your database: • For a Microsoft Excel 2003 spreadsheet file, select Microsoft Jet 4.0 . • For a Microsoft Excel 2007 spreadhseet file, select Microsoft Office 12.0 Access Database Engine . 3. Click Next . InduSoft Web Studio Page 423