How do you export specific data from XDB tables?

Problem:

How do you export specific data from XDB tables?

Resolution:

Within the SQL Wizard, select File -> New -> Export, and change the format to dsntiaul.

Select the table, and add a where clause as appropriate.

This will only export the data which meets the condition specified within the where clause, and will allow the data stored in the output .dsn file to be imported elsewhere.