Excel to Mainframe

Document ID : KB000027057
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

Do you use the DBXLOAD utility to load metadata into the Repository? If yes, have you loaded data from a Microsoft Excel spreadsheet into the AllFusion Repository For z/OS? If so, you may have found that text fields in your Excel sheet do not remain fixed when uploading to a mainframe dataset requiring you to manually align the text fields which can be very time consuming and cumbersome.

Solution

  1. Open the original Excel spreadsheet in Excel

  2. Select FILE .SAVE AS and select FILES OF TYPE (*. CSV ) Comma Delimited File

  3. Open the (*. CSV ) file in Excel

  4. Select FILE .SAVE AS and select FILES OF TYPE(*.PRN) Space Delimited File

  5. Upload the .PRN file to the mainframe