Excel into join table?

[ESpringer]

Dearest Gurus,

I've got an excel table whose *cells* (apart from row and column headers) *each* need a corresponding *record* in FM. (Each record would be based on three fields: rowheader, colheader, value) -- I'll then have more fields to add in FM9.

Essentially, I want to convert the sheet not into an ordinary table, but into a saturated join table for two existing FM9 tables (one organized around the columns in the Excel sheet, the other around its rows).

There must be an easy way... any hints?

[Brian C]

This sounds like you should import your excel spreadsheet into a temporary table. Once the data is in the temp table you can use a scripted process to process each record one at a time to step thru the fields for each record and have them create a corresponding record in your join table.

Does this make sense?