APPX Software Library

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

Load COUNTRY into Excel and Refresh It

Use the tested Legacy Microsoft Query route in 32-bit Excel. If the command is hidden, open File → Options → Data and enable From Microsoft Query (Legacy) under Show legacy data import wizards.

  1. Create a blank workbook and select Data → Get Data → Legacy Wizards → From Microsoft Query (Legacy).
  2. On Databases, select AppxODBC, keep Use the Query Wizard to create/edit queries checked, and select OK.
  3. Enter the APPX user and password in the Dharma login dialog.
  4. In the Query Wizard, expand dmo_dmo_country and add its nine columns to Columns in your query.
  5. Select Next, keep the first sample unfiltered, and sort by name.
  6. Select Next, keep Return Data to Microsoft Excel selected, and select Finish.
  7. In Import Data, choose Table, choose cell $A$1 on the existing worksheet, and select OK.
Excel's Legacy Microsoft Query loads all seven COUNTRY records.
Figure 10. Excel's Legacy Microsoft Query loads all seven COUNTRY records.
  1. Wait until Excel returns to Ready. The worksheet contains 7 data rows and 9 columns, plus the heading row.
  2. Select Table Design → Refresh, wait for Ready, and check the same seven complete records.
  3. Save the workbook locally. On reopening, refresh the external query and supply the APPX login when prompted.
Excel refresh completes with the same sample.
Figure 11. Excel refresh completes with the same sample.

The saved worksheet values match the native APPX sample after converting Excel date serials to dates. The workbook retains an external query that can refresh. Leave password saving disabled.