Home » RDBMS Server » Server Utilities » Import using Toad
icon4.gif  Import using Toad [message #172386] Tue, 16 May 2006 04:50 Go to next message
harsha18
Messages: 4
Registered: May 2006
Location: Hyderabad
Junior Member
I need to import data from an excel file into a remote oracle database using toad. Using the import->table data option in toad, I need to select the table into which I have to import and then click on "Show Data". But this will display all the records that are present in the database and so takes a lot of time. Is there any way by which I can skip this step and only insert the data into the table?

Thanks,
harsha18

Report message to a moderator

Re: Import using Toad [message #172389 is a reply to message #172386] Tue, 16 May 2006 05:10 Go to previous message
harman_deep
Messages: 8
Registered: August 2005
Location: Amritsar
Junior Member
I think y try SQL Loader utility ..it is meant for this

Report message to a moderator

Previous Topic: UTL_FILE
Next Topic: Urgent: ORA-29280
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 08:45:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.