Hi winja,
Firstly I have never worked with manufacturing but I think you could use a macro to import the files but you do need some programming knowledge.
Macros work by record what the user is doing. When you record a macro you can replay it as many times as you like. What you need to do is to record a macro of yourself typing in an example of a BOM. Then using excel or similar you can create a macro file by using the example you recorded and replacing the values you entered with your import values.
Using VBA in excel it is very easy to read data held on datasheet and write it out to file. This file would be your macro file.
Hope this helps,
JMG