AS400 reel files are exacting file output from IBM I series processor system. These files are typically debugging reports or raw database pulls from database sitting on mainframe in difficulty, and come in form of long, cumbersome text files. Getting spool files into desktop application, like MS Word or Excel, while keeping formatting going, can be done one of two ways.

Introductions:

• Carry out mainframe database question as normally would.

• Make spool file usually. When saving file, use CPYTOIMPF command to obtain output as comma separated value file (Extension of *.csv).

• Release MS Word or MS Excel.

• Open .csv file in Excel or Word.

• Click "Yes" on "Convert to Table" dialog box. This will split every value in spool file separated by commas into their own cells in Excel, or into their own table cells in MS Word. There is extremely fine possibility that will require doing wide reformatting of file to make it presentable.