Re: uploading the contents of an spread sheet

[Quoted] "Demetrius Sotiriades" <dsotiriades_at_wi.rr.com> wrote in message news:QEmbe.31933$215.28865_at_tornado.rdc-kc.rr.com...
> 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
>

if your working with 9iR2 and above, HTMLDB is a likely choice for this task -- at least the load part

you could also use SQL*Loader (available in all DB versions)

likely, you'll load the spreadsheet data in a working table, then use SQL statments to populate other tables

what database version are you working with?

++ mcs Received on Tue Apr 26 2005 - 13:00:08 CEST