AnsweredAssumed Answered

Cannot import Excel Database

Question asked by CLHuddleston on Sep 6, 2011
Latest reply on Dec 6, 2011 by TSGal

Summary

Cannot import Excel Database

Product

FileMaker Pro

Version

11.0v4

Operating system version

10.6.8

Description of the issue

Original tab-delineated database from Now Contact.  Converted successfully to Excel on a PC running Office 2010 and most current version of Windows.  All OS's and programs fully updated.

Have tried saving in various versions of Excel, both PC and Mac.  The Filemaker Import function does not recognize the .xls files (grayed out in the browser/selection box) and when I try to open .xlsx get the following:  "The selected Excel workbook has an unsupported file format.  Please convert the workbook to the Excel 2007, or Excel 2008 file format and try again."

Steps to reproduce the problem

I have tried saving this file in 97-2004 both Mac and PC as well as Excel 2010 in both Mac and PC.  Consistently the same result.

Expected result

Import of data into Filemaker Pro

Actual result

See above

Exact text of any error message(s) that appear

The selected Excel workbook has an unsupported file format.  Please convert the workbook to the Excel 2007, or Excel 2008 file format and try again.

Configuration information

See agove

Workaround

None

Outcomes