WPS Engine for DB Files

Data Engine Modules

Home 5 Products 5 Information 5 SAS language 5 Data engine modules 5 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
Writing
Updating
Creating New Tables
SPSS Compressed & Uncompressed 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.

Other data engine modules

WPS Engine for Actian Matrix

Library engine for accessing an Actian Matrix database

WPS Engine for DB Files

Library engine and procedures for accessing Access, Excel, SPSS and dBase files

WPS Engine for DB2

Library engine and procedures for accessing a DB2 database

WPS Engine for Greenplum

Library engine for accessing a Greenplum warehouse

WPS Engine for Hadoop

Library engine for accessing a Hadoop warehouse

WPS Engine for Informix

Library engine for accessing an Informix database

WPS Engine for Kognitio

Library engine for accessing a kognitio warehouse

WPS Engine for MySQL

Library engine for accessing a MySQL database

WPS Engine for MariaDB

Library engine for accessing a MariaDB database

WPS Engine for Netezza

Library engine for accessing a Netezza appliance

WPS Engine for ODBC

Library engine for accessing ODBC datasources

WPS Engine for OLEDB

Library engine for accessing OLEDB datasources

WPS Engine for Oracle

Library engine for accessing an Oracle database

WPS Engine for PostgreSQL

Library engine for accessing an PostgreSQL database

WPS Engine for SAND

Library engine for accessing a SAND database

WPS Engine for Snowflake

Library engine for accessing a Snowflake database

WPS Engine for SQL Server

Library engine for accessing a SQL Server database

WPS Engine for Sybase

Library engine for accessing a Sybase database

WPS Engine for Sybase IQ

Library engine for accessing a Sybase database

WPS Engine for Teradata

Library engine for accessing a Teradata warehouse

WPS Engine for Vertica

Library engine for accessing a Vertica database

WPS Engine for XLSX

Library engine for accessing Microsoft Excel spreadsheets

Have a question?

Get in touch with our sales team

Try or buy

Standard Edition
Academic Edition
Community Edition