AnsweredAssumed Answered

Importing blank rows from excel spreadsheets

Question asked by DaynaLeClair on Aug 22, 2011
Latest reply on Aug 23, 2011 by philmodjunk


Importing blank rows from excel spreadsheets


FileMaker Pro

Operating system version

Mac OS X 10.7.1

Description of the issue


I am creating a scientific database. To start I need to import the last 35 years of data from excel spreadsheets. However, whenever I import a spreadsheet, the blank rows at the bottom of each spreadsheet are also imported. This is adding over 100 blank records for each spreadsheet.

Any idea how to fix this without having to go into every spreadsheet and delete the blank rows?
Thank you