From Access Database Function

The $MSAccess function allows you to use data from Microsoft Access database as a data source. This function has following parameters:

  1. File Name*. String, the quotation is not required.
  2. Table Name. String, the quotation is not required.
  3. Column Name. String, the quotation is not required.

* - the following macros can be used as a part of the file name: %APPDATA%, %DOCUMENTS%, %USERPROFILE%, %ALLUSERSPROFILE%

Examples

$MSAccess(d:\databases\sales.mdb,Customers,Contact Name)

Limitation: the function is available for Windows systems only (C++ and .net editions of the pattern engine).