AnsweredAssumed Answered

How to import excel data into repeating fields of a single FP9 Pro record.

Question asked by RRNathan on Dec 24, 2008
Latest reply on Jan 5, 2009 by TSGal

Title

How to import excel data into repeating fields of a single FP9 Pro record.

Post

I like to create a recipe data base of meal items. Data is in Excel spreadsheets. For example, Recipe-1 has several components and each component will be added at different amounts. The components will be listed in repeating fields (about 50 per recipe) with the corresponding amounts also in repeating fields. I listed the components in column A and the corresponding amounts in Column B. I saved the Excel file as CSV tried to import into a newly created record. From the newly created FP9 record, I selected FILE – IMPORT – FILE. The import window showed that these will be considered as separate records. Each component and corresponding levels get separated into separate records, but I want them all to be in a single FP9 record (into each repeating field of the table). How can I stop them getting separated into several records? How should I set up the Excel table to accomplish this.

Outcomes