AnsweredAssumed Answered

Data Upload from Excel

Question asked by jveilleux on Apr 27, 2011
Latest reply on Apr 27, 2011 by jveilleux


Data Upload from Excel


FileMaker Pro


Advanced, version 11.0v3

Operating system version

Windows 7

Description of the issue

I've had to upload several thousand records, matching some and adding others.  Most upload OK, but I had some 500 that had 'errors' and did not get uploaded.  But when I repeat the upload, I'll have several (10 or so) that will upload and the rest contain 'errors'.  When I repeat the upload, I get a few more each time.  I recently got a new Dell Computer (Optiplex 780) with Windows 7.

Steps to reproduce the problem

Generate list of records to be uploaded in Excel
Import Records
select file (I've done it with both Office 2007 and Office 2003)
Match fields as needed

Expected result

All records uploaded.

Actual result

Several records do not upload.

Exact text of any error message(s) that appear

Import Summary:
Total records added/updated:  577
Total records skipped due to errors:  529
Total fields skipped due to errors:  0
Table created:

Configuration information



Screenshot is in Microsoft word format