Re: Loading data into oracle tables from .xls files

Hi !

If the structure of excel sheet matches/fits to the destination oracle table-sturcture, you can use MS WORD's mail-merge to create insert-sctipts.

I hope, this helps.
Best Regards
Gyula

RanganathK_at_lgcommerznow.com wrote:
>
> Dear DBA gurus,
>
> I have some data in Excel sheet which is in xls format which I have to
> load into Oracle tables. How do I do it? Any help in this regard will be
> highly appreciated.
>
> TIA and regards,
>
> Ranganath
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: RanganathK_at_lgcommerznow.com
>
> 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 Nov 30 2000 - 03:45:37 CST