Or save it and bring it into access (if it is small). Access has a way
to save via odbc into oracle.

-----Original Message-----
From: Stroh Kathleen (DTI)
[mailto:oracledba-ezmlmshield-x410059.[Email address protected]
Sent: Wednesday, September 07, 2005 8:48 AM
To: LazyDBA Discussion
Subject: RE: Import Data from Excel sheets


Or, save it as CSV, create an external table & use SELECT statements to
access the data (possibly to load to another table). This requires at
least Oracle 9i.

Kathy
-----Original Message-----
From: Giuliano Intrito
[mailto:oracledba-ezmlmshield-x38679810.[Email address protected]
Sent: Wednesday, September 07, 2005 7:37 AM
To: LazyDBA Discussion
Subject: Re: Import Data from Excel sheets

try to export your file as CSV and the import it with sql*loader

:-)

MIS wrote:

>Hi all,
>
>I want to import data from excel sheets.
>
>??
>
>abc
>
>
>--------
>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


--------
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



Oracle LazyDBA home page