Generate insert command in Excel and run on Sql Prompt.

Regards

Hrishikesh

________________________________

From: seramu [mailto:oracledba-ezmlmshield-x34583395.[Email address protected]
Sent: Thu 03/03/2005 19:54
To: LazyDBA Discussion
Subject: Re: Transfer Data



This is the way I've done in the past,,

1. Store this file as a common separated file .CSV
2. Use SQL*Loader with a minimal command (optionally) using control file.

-Aliyar Sahib




"Malavika Gupta "
<oracledba-ezmlms
hield-x33743903.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
03/03/2005 05:52
AM Subject
Transfer Data










Hello All,

I have my records in an Excel spreadsheet. Now I have created a table in
oracle database. Is it possible to insert all these datas at one time into
this table instead of writing "Insert" command for each record.

Thanks,
Malavika


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.

Oracle LazyDBA home page