I cook and take food photo. I build databases and love to talk about it.

Saturday, 21 February 2015

On 15:16 by Ronnie Rahman in ,    5 comments
At my current workplace, I use SQL Server 2014 and SSIS (SQL Server Integration Services) to do all database and ETL (Extract Transform Load) development work. Recently, I have started a degree course at University of Hertfordshire, where we use Oracle.... #OutofmyComfortzone already.

One of the fellow student posted a question on the university class discussion forum, asking if someone knows how to import data from Microsoft Excel spreadsheet to Oracle. I usually read every single post on the university forum and try to help if I know the answer on top of my head, if not, then first I learn myself and then reply on the forum with the answer. I find this the best way to learn something new everyday.

For this demo, I have used Oracle Developer Version 4.1.0.17 and Microsoft Excel 2007. To get started, lets create a simple Customer table first, and click here to download the Excel source file Customers.xls.

CREATE TABLE Customers
(
  CustomerID NUMBER(10) NOT NULL,
  FirstName VARCHAR2(35),
  LastName VARCHAR2(35),
  Town VARCHAR2(50),
  AccountCreationDate DATE,
  CONSTRAINT PK_Customers PRIMARY KEY
    (CustomerID)
  );

After refreshing (press F5) the table list on the left pane under Connections list, right click on the table name Customers and select Import Data. 



Follow the step by step Oracle Developer import wizard instructions below to import data from Excel spreadsheet to a Oracle database table

Locate the Excel source file
After selecting the Excel file click Next and follow on screen wizard instructions.

To map Excel date to Oracle Date format amend the format field to dd/mm/yyyy

Click on Finish


Downloads:

Customers.xls


5 comments:

  1. Credit score reporting is not something but oracle fusion procurement way in which feasible avail with alternatives to offer the client or the economic enterprise business enterprise with all the credit score and debt data
    thank for sharing information
    oracle fusion procurement online training
    oracle fusion procurement training

    ReplyDelete
  2. In normal circumstances, when data is being stored as a database in Excel it is arranged with each field being represented by a column and each record being represented by a row. excel reporting dashboard

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. All good. I am a newcomer, so I jerked until the money was withdrawn. I waited 2 days on Yandex. Thanks to the admins and support service for listening to my whining on the forum and in the chat. Play people! Do not be greedy. All the rules with this casino! perfectbest online slots I often spend my time here

    ReplyDelete