csv file

We have sold several product lines and I need to be able to export the single-level and multi-level BOMs to a excel file(s). There are ober 10k to export. Does anyone know of way to do a mass export? Is there a SQL statement available that would do it? Any suggestions?