The purpose of this white paper is to demonstrate how to use the ODBC driver plugin with Microsoft® Access® database files. This allows LISTSERV® Maestro to use Access databases as a data source, making it possible to have LISTSERV Maestro extract data directly from an Access database [3].

The ODBC driver plugin is a special database plugin that allows recipient information or drop-in content to be pulled from any ODBC data source. The ODBC driver plugin can be used in the recipient wizard with the “Select Recipients From a Database” recipient type [1]. It can also be used in the target group wizard with the “LISTSERV Maestro Retrieves Recipients from Database” target group type [3] to retrieve recipient information from an ODBC data source. Additionally, it can be used to create drop-in content elements by retrieving content information from a database [1]. ODBC drivers exist for many applications [5], making a wide range of data available to LISTSERV Maestro for recipient retrieval or drop-in content definition.

By connecting directly to an Access database, you can use any standard SQL statement to extract data. You can even use the Access tools and wizards for constructing your query and testing it within Access. Then, by switching from Design View to SQL View, you can copy the SQL statement from Access and paste it in to LISTSERV Maestro.

Download pdf Importing Data from Microsoft Access into LISTSERV Maestro