Welcome to MCAD Central

Join our MCAD Central community forums, the largest resource for MCAD (Mechanical Computer-Aided Design) professionals, including files, forums, jobs, articles, calendar, and more.

Register Log in

PRO bom to Excel...

jrobi

New member
is there a way to get a bom into a spreadsheet OTHER than saving the BOM as a text file and doing a wondows copy of that text file and pasting said copy into the spreadsheet? thanks in advance. JROBI
 

jr_tyco

New member
hi


you can make a bom format file with all the fields you need separeted by comma


save your bom into a file with the extension ".csv"


then open the file with excel using the filter "csv"


you re done
 

wali

New member
I have just gone through an exercise of importing a BOM into Excel and then formatting it to get all the NHA (Next Higher Assemblies) correct and importing it into an Access database.


The trick to get the BOM in text format into excel is first open Excel with a blank worksheet. Go to file open, and change file type to .txt and open the BOM. Excel takes you into a text import wizard, which allows you to adjust feild widths and set the format of columns.


Wali Crawford


Lodox systems - South Africa
 

Sponsor

Top