var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Data migration
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
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
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.
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 - Oracle FAQ