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


The information in this article applies to:

  • Microsoft Excel 2001 for Mac
  • Microsoft Word 2001 for Macintosh
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.

REFERENCES

For additional information about the Office 2001 Service Release, click the article number below to view the article in the Microsoft Knowledge Base:

294949 OFF2001: Readme for Microsoft Office 2001 for Mac Service Release 1 (SR-1)

Or, visit the Microsoft MacTopia Web site (http://www.microsoft.com/mac) for any additional updates.
Modification Type:MajorLast Reviewed:8/4/2006
Keywords:kbpending kbprb KB272903
©2004 Microsoft Corporation. All rights reserved.