Results 1 to 4 of 4

Thread: Data migration

  1. #1
    Join Date
    Sep 2010
    Posts
    153

    Unanswered: Data migration

    Hi guys,

    I have an excel sheet with 10 tabs (work sheets) and each work sheet contains data. I want to migrate all data once into my database table. Could you tell me the way to migrate?
    I need it urgently



    Thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Export the data to text files (tab-separated or comma-separated)
    Create the tables in Oracle using the approriate SQL statements
    Import the text files using SQL*Loader

  3. #3
    Join Date
    Apr 2012
    Posts
    2
    else create the insert script for the excel sheet OR Create the external table and load it... Please attach the excel sheet and table script.

  4. #4
    Join Date
    Feb 2012
    Posts
    26
    What did you do to migrate/import it to your tables? In my experience, I did use Toad for Oracle.. Or as shammat said, use SQL*Loader.

    SQL*Loader FAQ
    SQL*Loader FAQ - Oracle FAQ

Posting Permissions

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