Import from excel

[tusharguptait]

Hi,

I import data from excel to FM. Problem i am facing occurs when excel already has data which i clear and write new data. This new data should then be imported to FM. But FM still import the total number of previous rows.

eg. number of rows in old data = 100,

number of rows in new data = 10.

(100 rows are imported with last 90 rows being empty.)

Any solution to this problem will be greatly appreciated.

Regards

TG

[Fenton]

If you define a named range in Excel, and readjust it's size each time, then you can control which rows FileMaker imports. There's an option in the FileMaker Import (Excel) dialog to show Ranges instead of Worksheets.