AnsweredAssumed Answered

Import Find Criteria from Excel?

Question asked by straka_sh on May 15, 2014
Latest reply on May 15, 2014 by philmodjunk


Import Find Criteria from Excel?


     Here's the best example...

     We have an excel report that has a variable number of 5 digit record numbers (eg. 21639, 21643, 21839... etc).  It might be as few as 10 or as many as several hundred records.

     Is there a (easy) way to import an example of 256 records into find requests so I don't have to manually type in all 256 record numbers into my FM solution to bring up those matching records?

     I've thought of a separate table that I could import into and then use a calculation to find the matching records, but I have to import these into a repeating field, so that might be a little more cumbersome.

     Any ideas?