Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2012
    Posts
    4

    Unanswered: Validating excel sheet with an oracle table data

    Hello Team,

    I am sure this question might have been answered long time back. I need to validate an excel sheet data and find certain match records from one table and then to replace it with a new value in table.

    Any idea how I can get this done.

    Thanks in advance!!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >. I need to validate an excel sheet data
    post an example of an invalid excel sheet data.
    What does this question or solution have to do with Oracle RDBMS?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2012
    Posts
    4
    Lets consider the column A have the certain customer account number and column B new customer account number. I have these customer account information available in Oracle table customer_acct. I need to compare the data from excel sheet with current account number in customer_acct, if this is available in this table update with new customer account number.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Oracle can not access cell data inside any Excel spreadsheet.
    So only solution would be to write Visual Basic or similar to match your requirements.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2012
    Posts
    84
    Hello,

    SQLDeveloper has facilities that makes easy to import data from excel sheet into a table.
    Just create a temporary table, import excel sheet into this table and run a query that compares data and updates the original table.

Posting Permissions

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