Importing Excel - how to get rid of extra rows?

[Alisun]

Hello,

I have an Excel document that has 30 rows. However, every time I import it into Filemaker, the database shows 218 records. Every record after 30 is empty, because on the Excel spreadsheet, every row after 30 is blank.

How do I tell Filemaker to import *ONLY* rows in Excel that have data?

-Alisun

[aldipalo]

In excel set up a named range selecting the columns and rows you want to import. Then tell FM to import the named range and you SHOULD get the results you want. Make sure to tell FM the first row is a fieldname (If that is so of course) :