inserting .xls file into oracle.

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • manoj182039
    New Member
    • Sep 2006
    • 1
    #1

    inserting .xls file into oracle.

    hi i am manoj new to this group

    in website the user will upload the .xls (excel sheet ) i want to load the excel sheet value into my staging table. how can i do that.
    Tags: None
    • saravanankm
      New Member
      • Jul 2006
      • 47
      #2
      hi!

      do U want to Implement through PL/SQL or Any other front end tool?

      pls Reply Soon....


      By
      Captain

        Comment

        • shrrinivas
          New Member
          • Apr 2007
          • 1
          #3
          through pl/sql procedure how we upload data from .xls file into oracle db

            Comment

            • debasisdas
              Recognized Expert Expert
              • Dec 2006
              • 8119
              #4
              It will be easier if the file is in .CSV format.

              Then u can use SQL*LOADER to load data into table.

              again for this the data should be in specified format.

                Comment

                • karthiksravan
                  New Member
                  • May 2007
                  • 1
                  #5
                  Yaa please send that pl/sql procedure plzzzzzzz


                  Originally posted by saravanankm
                  hi!

                  do U want to Implement through PL/SQL or Any other front end tool?

                  pls Reply Soon....


                  By
                  Captain

                    Comment

                    Previous template Next
                    Working...