Data Engine Module

WPS Engine for DB Files

PC File Access

The WPS Engine for DB Files module presently provides access to the following types of file:

  • dBASE (version 2, 3, 4 and 5)
  • SPSS (version 6 single byte files)
  • Microsoft Excel (version 95, 97, 2000, 2002, 2003, 2007 and 2010)
  • Microsoft Access (version 97, 2000, 2002, 2007 and 2010)
Type of Access Supported?
Reading Yes
Writing Yes
Updating * Yes
Creating New Tables Yes
SPSS Compressed & Uncompressed Files Yes

*Updating is not presently supported for SPSS data files.

Microsoft Access

Interfacing to Microsoft Access using the WPS Engine for DB Files also requires a Microsoft ACE library to be installed. The ACE library is only available from Microsoft. The WPS Engine for OLEDB provides an alternative option to interfacing with Microsoft Access but still requires the Microsoft ACE Library to be installed.

Microsoft Excel

Interfacing to Microsoft Excel spreadsheets is best achieved using the alternative WPS Engine for XLSX. Unlike the WPS Engine for DB Files, the WPS Engine for XLSX does not require any additional Microsoft libraries to be installed and works across all supported WPS platforms, not just Windows.

Dependencies and Usage

The Access and Excel parts of the WPS Engine for DB Files can only be used on the Windows platform.

Please enable JavaScript to get the best out of our website. You will be unable to do certain things without it, including logging in, registering or filling out our contact forms.