Results 1 to 4 of 4

Thread: Import different sheets of single CSV file in to different E1 Tables

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    New Member
    Join Date
    Jun 2008

    Question Import different sheets of single CSV file in to different E1 Tables


    I need your assistance on the requirements as "To import a single input CSV file which has three sheets to the three different custom JDE Tables" .
    Do we have any options in UBE to import different sheets of a single CSV to the three different E1 tables at a time.

    Appreciate your valuable inputs.

    JDE Application :E900
    Tools :


  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Spokane, WA, USA
    Unless I'm quite mistaken CSV files don't have "sheets". A CSV file is just a text file with a .CSV extension that has comma separated values.
    Your requestor probably doesn't realize this.
    Larry Jones
    E1 9.2 - TR on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3
    New Member
    Join Date
    Jun 2008
    Thank you Larry for your reply.

    I am sorry. It is a Microsoft Excel document with three sheets which needs to be imported to E1 Custom tables.

    Thanks in advance for your assistance.


  4. #4
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Cork, Ireland
    If you spread those sheets out into single files, you have many options open to you. Does your data need to be in one file?

    I am not sure if Dropzone made by Stelitx can do multiple sheets, but it's designed to take an excel file and suck data into forms via 'magic' (AIS) Works really good.
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR Unix

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.