p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Oracle (http://p2p.wrox.com/forumdisplay.php?f=105)
-   -   How to pull excel data into oracle tables (http://p2p.wrox.com/showthread.php?t=64128)

yogeshyl November 28th, 2007 03:29 AM

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.


Yogesh

rava_m January 9th, 2008 12:38 PM

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 ;)

Ravi



All times are GMT -4. The time now is 08:43 AM.

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