multiple records into one

[pbucc]

hi all,

i have to take information per suite for a condo from a excel file and plug them in to my fm database. in the excel file i have 3 to 4 rows per suite that provide different information, but the first cell of the row is the suite number.

ok here is my problem.... i have imported an excel file into my fm database. i have 3 to 4 records that belong to one suit number, and i have made scripts to cut and paste the infomation into their own fields. now i need make one record (suite) with all parts of information.

thanks

[Ender]

Greetings,

I think it would be easier to import each row's data separately (import all the row1 data for all suites, then import all the row2 data for all suites, etc.,) provided that the data is formatted such that it is always in the same relative place for all suites.