Oracle Discussion Forums
Welcome, Guest. Please login or register.
September 10, 2010
Home Help Search Login Register
News:


+  WebForums - OraclePassport
|-+  IT Programming - UNIX, Java, MySQL, Toad
| |-+  Quest Toad - Discussion Board
| | |-+  xls to table
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Send this topic Print
Author Topic: xls to table  (Read 409 times)
kushi
Professional
****

Appreciate? +7/-0
Offline Offline

Posts: 140

« on: April 17, 2009 »

How to insert xls data to table using Toad ?
Report to moderator   Logged

Kushi
dtech-team
Administrator
Assistant Professor
*****

Appreciate? +5/-0
Offline Offline

Posts: 616


DTecH Oracle Forums

WWW
« Reply #1 on: April 17, 2009 »

Option 1. Import Utility:

   I guess there is an import utility in TOAD under the Database Menu. Almost all file types can be used. Not sure about xls files. If not possible, convert them to csv files.

Option 2: SQL Loader in TOAD

    This is a much better one, which I have used many times. Just convert the .xls to.csv (Just do a 'save as' .csv). Then take the SQL Loader Wizard from DBA Menu.

Build a control File or create one of your own. Click next, add source file. (input, bad, control files). Then Load. :)

 
Report to moderator   Logged

Pages: [1] Go Up Send this topic Print 
« previous next »
 
Share this topic...
In a forum
(BBCode)
In a site/blog
(HTML)



Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 2.0 RC1.2 | SMF © 2006–2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 0.181 seconds with 19 queries.