Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 28th, 2007, 03:29 AM
Authorized User
Join Date: Apr 2007
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to pull excel data into oracle tables

In my oracle database, i had 10 columns in a table out of which 3 columns are also available in a excel file. I want to update the data in oracle table by pulling data from those 3 columns in my excel file.

Please give me sql query to do this in toad.

Old January 9th, 2008, 12:38 PM
Registered User
Join Date: Jan 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

Hi Yogesh,

Are you still looking for the solution?

Well I dont know SQL query, but you can pull data into Oracle by
1) first convert excel file into csv file
2) Now by using SQL loader you can load data into the required table.

Hope this will help ;)


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to pull data between two different HTML tag boniggy Visual Basic 2005 Basics 0 February 6th, 2008 02:36 AM
Pivot tables in Excel with cubes as data source boson SQL Server 2000 2 January 28th, 2005 07:16 AM
Pull info from 2 tables stacy Classic ASP Databases 6 March 19th, 2004 10:46 AM
Can't pull data from ntext field into recordset. rstelma SQL Server 2000 2 August 26th, 2003 04:50 PM
Can't pull data from ntext field into recordset. rstelma Classic ASP Databases 1 August 26th, 2003 03:21 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.