Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    13

    Unanswered: Loading flat file to oracle table?

    i am oracle beginner

    Can anyone tell me how to import a text file or a excel format file into a oracle table...

    thank you much

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Exclamation

    You have to use the sql loader utility.

    http://download-west.oracle.com/docs...a90192/toc.htm

    For excel, first export the data to a CSV (comma separated values) file, then user sql loader.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jul 2003
    Posts
    13

    Thumbs up thx thx

    thx for yr teaching, u really very helpful!



    Originally posted by LKBrwn_DBA
    You have to use the sql loader utility.

    http://download-west.oracle.com/docs...a90192/toc.htm

    For excel, first export the data to a CSV (comma separated values) file, then user sql loader.


Posting Permissions

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