Microsoft KB Archive/272903

= OFF2001: Excel and Word Cannot Import Data from FileMaker Pro Databases That Contain JPEG, PICT, or TIFF Files =

Article ID: 272903

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac
 * Microsoft Word 2001 for Mac

-



This article was previously published under Q272903



SYMPTOMS
In Microsoft Excel 2001 for Mac, when you attempt to import data from a FileMaker Pro database that contains JPEG, PICT, or TIFF pictures, the FileMaker Import Wizard does not import any data and you receive no warning or error message.

Similarly, in Microsoft Word 2001 for Mac, when you attempt to import data from a FileMaker Pro database that contains JPEG, PICT, or TIFF pictures, the FileMaker Import Wizard fails to import any data. However, you do receive the following error message:

Word was unable to open the data source.



CAUSE
When Container fields in a FileMaker Pro database contain JPEG, PICT, or TIFF files, the records can not be imported correctly by Excel 2001 for Mac and Word 2001 for Mac.



RESOLUTION
To resolve this problem, download and install the Microsoft Office 2001 Service Release 1 file. To do so, visit the following Microsoft Web site:

http://www.microsoft.com/mac/downloads.aspx?pid=download&location=/mac/download/office2001/update_905.xml&secid=10&ssid=25&flgnosysreq=True

To temporarily work around this problem, make a copy of the FileMaker Pro database and delete any Container fields that contain JPEG, PICT, or TIFF files. Use the edited copy of the database when you want to import the data into Excel or Word.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2001 for Mac Service Release 1.



MORE INFORMATION
For more information about how to import data from a FileMaker Pro database, follow these steps:
 * 1) On the Help menu, click Contents and Index, click Index, and then click D.
 * 2) Scroll down until you locate database, and then click the arrow to the left to view a list of topics under the general topic.
 * 3) Click Ways to retrieve data from an external database.

If you cannot find the information that you want, ask the Office Assistant.

For more information about merging data in a document, follow these steps:
 * 1) On the Help menu, click Contents and Index, click Index, and then click M.
 * 2) Scroll down until you locate Merge, and then click the arrow to the left to view a list of topics under the general topic.
 * 3) Click Overview of data merge.

If you cannot find the information that you want, ask the Office Assistant.

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

