Re: Need to automate the FTP of EXCEl file to Mainframes



I have seem similiar process.
Use VB to extrat the excel into a Tab Delimited file. (There are
features to create a dump of the excel file. Don't use them)
Have a batch file run automatically every night or morning to run this
VB program

On the mainframe job add an FTP step to retreive the data whenever
required.



On Apr 18, 2:17 am, svpnu...@xxxxxxxxx wrote:
I need to automate the ftp of execl file to mainframes and read it
through a cobol program.
I am reading thru cobol program after saving it as a text tab
delimited file.
But now want this conversion of excel file to text tab delimited file
to happen wothout using a macro. can someone help me out?


.



Relevant Pages

  • 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 ...
    (comp.lang.cobol)
  • 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 ...
    (comp.lang.cobol)
  • 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 ...
    (comp.lang.cobol)
  • export datatable to excel
    ... #1 Is there a quick way to export a datatable to an excel file? ... Or delimited file? ... #2 Where is the appropriate Microsoft monitored group to ask about writing reports in SQL Reporting services or SQL Server Business Intelligence Development Studio or whatever it's called? ...
    (microsoft.public.dotnet.languages.vb)
  • Converting from CSV to Tab Delimited
    ... I am having trouble converting from comma delimited to to tab delimited. ... When I convert from a comma delimited file to a Excel file the rows and ... When I try to save as a tab delimited file it throws my ... The person I am working with can convert this file fine on his workstation, ...
    (microsoft.public.excel.misc)