Results 1 to 4 of 4

Thread: Forms 6i

  1. #1
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unanswered: Forms 6i

    hi,
    I need a working example for loading data from MS Excel spreadsheet into Oracle Table using Oracle Forms 6i

    Thank you,
    mr_roomi

  2. #2
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unhappy comments

    any comments?
    mr_roomi

  3. #3
    Join Date
    Jun 2004
    Posts
    4
    Hi, mr_roomi
    You can download this example from site http://www.etlsoftware.com/
    Just save your MS Excel spreadsheet as " tab delimited (*.txt) " or as
    " comma delimited (*.csv) " before loading data.

  4. #4
    Join Date
    Apr 2004
    Posts
    246
    If the file can be found from the server (on the server, network drive...) then use external tables. Otherwise you can use text_io to loop through the file and insert the rows one at a time, or (not classy, but it works) use text_io to build a .ctl file, and then do a HOST to call sqlldr.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •