Solved

load data

Posted on 2013-01-05
4
352 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.

914 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now