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

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you use the FileMaker Wizard to import data into your document, you encounter the following problems:

• The data that is imported into your Microsoft Excel worksheet is not sorted.
• The sort order that you had applied to your FileMaker database is removed.

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

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 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.

Additional query words: OFF98

Keywords : kbconversion
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb