XL98: Data Imported from FileMaker Pro Is Not Sorted the Same Way as in FileMaker Pro (228748)

WORKAROUND

To re-sort your database in FileMaker Pro or sort the imported data in Excel, use the appropriate method below.

How to Restore the Sort Order in Your FileMaker Database

To restore the sort order that you had applied to your FileMaker database, follow these steps:

1. Start FileMaker Pro.
2. Open the database for which you want to restore the sort order.
3. On the Mode menu, click Sort.
4. Click Sort.

How to Sort the Data That Was Imported into Your Worksheet

If you have imported data into a Microsoft Excel worksheet, you can use the built-in sorting tools to sort the result of your query. To do this, follow these steps:

If You Want to Sort by One Field

1. Click the cell that contains the field name of the field that you want to sort.
2. Click the Sort Ascending or the Sort Descending button on the Standard toolbar, depending on the order that you want to sort your data.

If You Want to Sort by More Than One Field

1. On the Data menu, click Sort.
2. In the Sort by list, click the field that you want to sort by. Click Ascending or Descending, depending on the order that you want to sort your data.
3. In the Then by list, click the second field that you want to sort by. Click Ascending or Descending, depending on the order that you want to sort your data.
   
   Skip to step 5 if you don't need to define any more fields to sort by.
4. In the second Then by list, click the third field that you want to sort by. Click Ascending or Descending, depending on the order that you want to sort your data.
5. Click OK to sort your data.