Solved

load data

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query 34 116
create a nested synonym 4 28
update statement in oracle 9 29
Procedure syntax 5 40
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
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.

830 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