Dear Chris ,
Who said you that the data in the assembly's BOM table is not linked to informations that are in the parts or sub-assemblies.
In a part or assembly click the tab configurations and then right click on the configuration that you want or the default if you have only one.In the configuration properties fill the field "Description" and check the box "Use in bill of materials". Everything that you have texted in this field will be transfered to the same field in the assembly's BOM.
In the same tab you can see the "Bill of Materials Option".Click on the field and choose what of the 3 options you want to be seen in the BOM.You have also a "User specific name" that you can write a text of your own.So when you have made the Bill of Materials(BOM) of the assembly that you are working the informations will be in it.
You can now export the table in an Excel sheet by right clicking the frame of the table and choosing "Save As" from the pop-up bar choose Excel.xls and type a name that you want to be saved.
Did I helped you?
Thessaloniki , Greece
Your solution didn't quite work. The tables that I am working with is not the BOM, It's a general table that is used as a wiring table.
Can you just open the cell formatting options in excel and change it back to "general" or something other than a date?