We are trying to import a bom directly from solidworks into Opera 3 (stock/purchasing/accounts program) without modifying it in Excel first. When we import the bom into Opera 3 via excel we have to have the information set out correctly in Excel for Opera 3 to read it correctly.
This is how we have to enter it in to Excel:
|Assembly no||Part no||Quantity|
We don't want to assign the assembly number to each part (property) as the parts may be in other assemblies and we don't want to enter it in manually. Is there any way we can create a new column, call it assembly no, and then get it to read the assembly number in the title bar of the drawing for each part listed or something very similar.
I hope you you can help me but please bear with me as I newbie.