Microsoft KB Archive/228748

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

Article ID: 228748

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q228748



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
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.
 * 1) 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.
 * 2) Click OK to sort your data.

Additional query words: OFF98

Keywords: kbconversion kbprb KB228748

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.