Re: Uplodading data from excel file into oracle table

Hi,

What abt exporting to MS-Access db and then migrate to Oracle (thru wizard - provided by Oracle)...?

( or )

Can even export to a flat file ( i think u can specify column delimiter and all while exporting ), then use SQL Loader to upload into Oracle.

Hope this may help.

regards,
Arul.

bipin sahani wrote:

> Hi All,
> I want to upload a data into oracle table from excel
> worksheet.In my oracle table there are 60 fields.And
> my execl contains only those fileds which are NOT NULL
> in table.So I've about 16 fields in my excel which is
> having around 5000 rows.What's the best possible and
> simplest way to upload this data in table from this
> EXCEL WORKSHEET.
> Any help regarding this will be greatly appreciated
> Thankx in Advance
> Bipin
>
> ____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.in address at http://mail.yahoo.co.in
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?bipin=20sahani?=
> INET: bipinsahani_at_yahoo.co.in
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Jan 11 2001 - 03:14:16 CST