Blank Records

[Bikeman17]

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?

[Lee Smith]

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

[Bikeman17]

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

[Lee Smith]

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