Upload Excel multiple sheets to AS/400

25 pts.
Tags:
AS 400
Microsoft Excel
I want to upload Excel multiple sheet to AS/400 by batch program but program upload first sheet only, not upload sheet remaining.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    What does you batch code look like? If you know the name of the other sheets in the workbook just add them to the bath process.
    134,720 pointsBadges:
    report
  • supawichc
    Batch code
    @ECHO OFF
    D:
    RFROMPCB D:\tmp.dtt
    PAUSE

    exit

    tmp.dtt code

    [DataTransferToAS400]
    Version=2.0
    [HostInfo]
    CrtOpt=2 
    Database=*SYSBAS
    FRFFile= 
    FileText= 
    HostFile= 
    HostFileType=
    HostName= 
    MbrText= 
    ObjAuth=0 
    RecLen=92
    [ClientInfo]
    ConvType=0 
    FDFFile=D:\xxx.FDF
    PCFile=D:\xxx.xls
    PCFileType=16
    SendExtraSheets=63
    UseFDF=
    [Properties]
    AllowNumericsInChar=0 
    AutoClose=0 
    AutoRun=0 
    Check4Untrans=0 
    Convert65535=
    ConvertExcelDateTime=0 
    ConvertTabs=0 
    DisSysName=0 
    Notify=
    ShowWarnings=0 
    UseCompression=
    UseSSL=2 
    UserOption=0 

    name of the other sheets in the workbook is xxx y.
    xxx = name of file
    y = number of sheets in the workbook

    ex. 
    file name xxx.xls
    name of sheets xxx 1,xxx 2,xxx ....
    25 pointsBadges:
    report
  • supawichc
    Can you tell me? That should fix it?
    25 pointsBadges:
    report
  • ToddN2000
    Are you copying the same cell range from each sheet into the same file? Do they have the same data format?
    134,720 pointsBadges:
    report
  • ToddN2000
    Also what version of Excel and Client Access are you using. IBM kind of was leaning towards other options of data transfer starting with Excel 2010 or 2013.
    134,720 pointsBadges:
    report
  • ToddN2000
    Found a few links that may help. It looks like they stopped support with Excel 2013.


    134,720 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: