Solved

load data

Posted on 2013-01-05
4
356 Views
Last Modified: 2013-01-25
SQL> create table Customers(CustomerId Number,FirstName VARCHAR2(30),LastName VARCHAR2(30),Address VARCHAR2(30),City VARCHAR2(30),State VARCHAR2(30),Zip VARCHAR2(30),Country VARCHAR2(30)) tablespace users;

Table created.

SQL> desc Customers;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CUSTOMERID                                         NUMBER
 FIRSTNAME                                          VARCHAR2(30)
 LASTNAME                                           VARCHAR2(30)
 ADDRESS                                            VARCHAR2(30)
 CITY                                               VARCHAR2(30)
 STATE                                              VARCHAR2(30)
 ZIP                                                VARCHAR2(30)
 COUNTRY                                            VARCHAR2(30)

SQL>



Can you please help me a step to load from the readonly excel sheet
I attached excel sheet...
Access2007PureSQL.accdb
data.png
0
Comment
Question by:walkerdba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 500 total points
ID: 38748329
if you have toad/sql developer then u can load this easily using the GUI

Look out for Menu

I think it would be under this in Toad

Click on Database Menu
Click on Import
Click on Import Table Data

It will open up a wizard showing schema name , table name on to which data has to be loaded and other options such as commit after loading etc.,

select appropriate table name and click on next-and select options to map the column name to headers in excel sheet and click next...your data load will be done..

I am not sure of the under which menu option this facility is available in SQL Developer,, but it should be the more or less the same as toad.
0
 
LVL 14

Expert Comment

by:ajexpert
ID: 38748529
Is this exercise for 1 time or repititive?

If repititive than I suggest using SQL LOADER or may be using EXTERNAL TABLES.

Do let us know

If your requirement is NOT repititive, I echo with wasimibm.

Here is the link, where someone has nicely presented how to import data from XLS using TOAD.

http://www.youtube.com/watch?v=N3PWEJaXKxI

HTH
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 38749206
if you want sample data and you have toad
then that option is also in the right click menu on the table
0
 

Author Closing Comment

by:walkerdba
ID: 38821447
yes
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle numeric condition check 4 47
Oracle 12c Default Isolation Level 17 62
format dd/mm/yyyy parameter 16 59
Oracle perfomance issue. 4 48
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question