Demetrius Sotiriades wrote:
> Hi,
>
> I have never worked with Oracle before and I need to update a database with
> the contents of an Excel spreadsheet. Since I do not have the database
> structure the first order of business is to be able to examine the database
> so that I can figure out where this data needs to go. The only tool that I
> have available to me at the moment is SQL plus.
>
> Is this tool adequate for this purpose and if not does anyone know what tool
> would be?
>
> I assume that Oracle has a pretty thorough toolset for doing just about
> anything that one would wish to do with a database. At the very least I need
> something more or less equivalent to SQL Server's Query Analyzer.
>
> Any suggestions would be deeply appreciated.
>
> Thanks in advance,
> Demetrius
>
>
Check out if this will help.
http://www.oracle.com/technology/products/database/htmldb/viewlets/htmldb_quicktour_viewlet.html
There is a demo for uploading spreadsheet data into a table.
Received on Tue Apr 26 2005 - 06:52:59 CDT
