Importing Excel file issue

[nickr]

Hi Forum,

I'm relatively new to FmP. When I import an excel spreadsheet into my database, FmP is importing every single row of the excel file, that's some 65,000 rows when I only have maybe 34 rows of data to import.

How can I stop it from doing this? Thanks.

[bcooney]

It's really Excel's problem. Somehow your "Last Cell" in Excel is way past your last data row. Select the data range and copy into a new worksheet. Import that.