PRO bom to Excel...

[jrobi]

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]

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]

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

 

[jfausch]

Here is an article about an application that will allow you to export directly to Excel;


http://www.proe.com/feature_full.php?cpfeatureid=20#


Note; you will need a login