1 Reply Latest reply on Aug 23, 2011 11:48 AM by philmodjunk

    Importing blank rows from excel spreadsheets

    DaynaLeClair

      Summary

      Importing blank rows from excel spreadsheets

      Product

      FileMaker Pro

      Operating system version

      Mac OS X 10.7.1

      Description of the issue

      Hello;

      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

      Dayna