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?

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?