APPX Software Library

Connecting other software

APPX ODBC 5.5.2 Cookbook (32-bit)

APPX 5.5.2, 32-bit clients 8 chapters, 48 topics
Start reading Download the PDF (1.4 MB) Connection glossary

Choose another APPX version or 32/64-bit edition

Updated October 20, 2026: SQL names, reserved words and views checked. Verified October 15, 2026 on Windows 11 Pro 25H2. Matching 5.5.2 engine/gateway/ASQL and supplied Dharma 9.01 x86 driver. WinSQL, Excel, enriched PowerShell, Base direct SQL and Calc passed. Crystal Reports 2016 passed an ODBC (RDO) SQL command, including save/export and fresh refresh. Repeated Access imports fail; the nearest verified Access success is documented in 5.5.3.

  1. Chapter 1Before You Start

    Check the tested setup, connection names and software needed for this edition.

  2. Chapter 2Install and Check APPX ODBC

    Install the gateway and driver, then check the connection settings.

  3. Chapter 3Make APPX Files Available to SQL

    Use ASQL to create and update SQL table definitions for APPX files.

  4. Chapter 4Read APPX Data with WinSQL

    Connect, run a query and check the returned records.

  5. Chapter 5Read APPX Data with Excel, Access and LibreOffice

    Follow the tested procedure for each desktop program.

  6. Chapter 6Create Reports with Crystal Reports 2016

    Choose the tested connection method, build a report and refresh its data.

  7. Chapter 7Read APPX Data with 32-bit PowerShell

    Query records, filter results, export files and inspect connection details.

  8. Chapter 8Solve Connection and Import Problems

    Check errors and settings, record diagnostic logs and turn logging off afterward.