DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Read from file

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    Read from file

    Hi

    If i have a text file with columns like student id, register date seperated by comma, how do i import it into a table in oracle? Is there a limit on the size of the file? Does it work for excel file too?

    Thanks!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can use sql loader, utl_file, csv, odbc etc

    if i´s plain text sql loader would be the fastest way

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: Read from file

    Originally posted by mooks
    Does it work for excel file too?
    No, you will have to save Excel as csv for input to sql loader.
    Last edited by DaPi; 04-24-2003 at 04:16 AM.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  4. #4
    Join Date
    Jan 2000
    Posts
    387
    Is there any example or references i can read on?

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    It's in the Server Utilities manual in the Oracle doc, also on http://download-west.oracle.com/docs...6955/part2.htm
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Have a look here

    http://otn.oracle.com/pls/tahiti/tah...loader+#a76955

    regards
    Hrishy

  7. #7
    Join Date
    Jan 2000
    Posts
    387
    Thanks everyone!

Posting Permissions

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


Click Here to Expand Forum to Full Width