Hello All,
I'm looking for some better and faster methods to be able to access all the information contained with the BOM of an assembly document.
Currently I collect this information into a dataset and append it to a table in SQL Server using a SQLBulkCopy (this part is all good, fast) but getting the information into the dataset is slow with the method I am currently using and wondering if maybe there is a faster way?
I cycle through the all levels BOM view row by row drilling down on every assembly like:
"For i = 1 To oBom.BOMViews(2).BOMRows.Count"
and start a new loop for every sub assembly.
I need the file path, part number, material, description, and qty per assembly.
I created and loaded BOM View configurations as well, exporting to Excel then reading the Excel file, better but I'm hoping you may have better methods then my duct taped work arounds LOL
Thanks all,
