Akke, you are correct in that it is not easy to work with the archaic Pro/Table tool. For the large number of pattern identities that you have, it would be fairly tedious to manually type in the data. Thank you for your courteous response.
First, let me say that using a relation in a pattern, such as robertib has described, does work. I tend to shy away from using them as much as I can because they are difficult to decipher if you are not the creator. Sometimes its hard even if you did create it. This is why I suggested the table because they are very easy to go back and edit.
That said, there is a way to write your own pro/table in excel. I worked with a fellow eng-tip author this morning to figure this out.
1. On the table pattern toolbar select Tables.
2. Highlight the active table, right click and select Write. This will write the selected table to your workspace folder on your C drive.
3. Rename the table file and remove the “.1” from the end (Ex. table1.ptb.1 to newtable.ptb)
4. Open this file with notepad or comparable program.
5. Copy the data from your excel file(no headings) to the table file and save.
6. In ProE, right click in the table tab, same location as before, and select Read.
7. Choose newtable.ptb and set active.
I know it seems pretty intense, but a little work now will pay off if someone needs to edit later. Feel free to do what you like, I just wanted to get this information out there in case anyone needed to work with Pro/Table. Maybe they fix this WF4 or 5.
grimmy