11 Replies Latest reply on May 16, 2017 12:15 PM by philmodjunk

    Importing from an excel sheet


      Hi every Body,

      I am trying to start  a  filemaker solution using fm pro 15 that import data from an excel sheet every month into an already existing table.


      My question is, How can I identify the excel sheet cells that I want to collect the data from? because the excel sheet that I am using has a merged-cells title in the top and another one in the bottom for signature and I don't know how to exclude these from being transfered


      Thanks a lot in adnvance for your answers




      Thank you so much for answers and advices,

      and sorry for not being able to respond yesterday 'cause I got really tied up.

      The problem is I've never worked with importing for filemaker so most of your suggestions were way over my head.

      I think importing from a range limit might work for what I need but I could be wrong.

      I've attached an example of an excel sheet that I want to work on.

      any detailed suggestion would be appreciated

      Thanks again for your help


      Message was edited by: yasir ali