We have a large number of 2D AutoCAD drawings with separate Excel parts list for each drawing which we want to bring into SolidWorks PDM Professional (formally EPDM) and at the same create BOM content that can be exported to our ERP system via an XML file. Could this be achieved by creating

SolidWorks virtual assemblies for each Excel parts list and how would we manage the relationship between the AutoCAD drawing and SolidWorks BOM? Are there any other possible solutions?