Need to save file for mainframe

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rick (Rick_at_discussions.microsoft.com)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 13:21:07 -0800

I have data that has been pulled in from a query in access and saved as a tab
delimited file. I have then imported it into Excel with the hope of
formatting this data into the proper specs for upload to a MainFrame. I want
to pad some of the fields with either an empty space or with zeroes. Within
Excel I have created a custom filter to accomplish this task. When I export
however, I am unable to save the file with the proper formatting (no matter
how I save this file). I end up with a tab delimited file instead of being
able to combine theses fields with the proper zeroes or spaces. Can anyone
help with this?

Example:
1-2 record code
3-14 Numeric
15-24 Numeric
25-36 Amount
37-44 Date
etc,etc...

Rick

Relevant Pages

  • Re: Need to save file for mainframe
    ... It sounds as if you need a fixed-width-field file, not a delimited file. ... "Text files and Excel." ... > formatting this data into the proper specs for upload to a MainFrame. ...
    (microsoft.public.excel.misc)
  • Re: Need to automate the FTP of EXCEl file to Mainframes
    ... But now want this conversion of excel file to text tab delimited file ... to happen wothout using a macro. ... How do you expect the Excel spreadsheet to export itself as a Tab delimited ...
    (comp.lang.cobol)
  • Re: New Workbook Is Huge
    ... Excel has a 1 million row size work sheet. ... When you import your tab ... delimited file it will appear on this sheet. ... Excel and total ignorance of the program...please forgive me. ...
    (microsoft.public.mac.office.excel)
  • Text (Tab) Delimited Input
    ... I have a Text (Tab) Delimited file (saved from Excel) that gives me problems ... with data types = "number" in the Access table. ...
    (microsoft.public.access.externaldata)
  • Re: Need to automate the FTP of EXCEl file to Mainframes
    ... I am reading thru cobol program after saving it as a text tab ... But now want this conversion of excel file to text tab delimited file ... How do you expect the Excel spreadsheet to export itself as a Tab delimited ...
    (comp.lang.cobol)