Hi there

I imported around 900 records into a fm pro db from an Excel db (.xlsx) . It's all there but when I go back to the db, I got 900 empty records. The data is gone but the records are still there???

The Start script checks fine. No weird action to perform. Just a simple sort.

Any ideas?

Hi Bikeman,

It's been a long time since I used Excel (Apple's OS upgrades killed my copy of Office). 

Is .xlsx comparable with FileMaker?

Have you tried exporting it as a .tab or .csv file?

Select the area to be exported?

Lee

The issue seems to come from the client's Excel file. Some restrictions must be implemented

I've fixed the issue  by exporting the newly data from the fm db to a new Excel file. Then reimported the data in the fm db. Then no empty records

Hi Bikeman,

37 minutes ago, Bikeman17 said:

exporting the newly data from the fm db to a new Excel file. Then reimported the data in the fm db

I don't see how an additional export and import changed the, "Now-you-see it", "Now-you-don't", "Now- you-see-it again", but glad you found a solution.

Lee