Re: uploading the contents of an spread sheet

Thank you,

I think that I am working with version 8 but I will verify that later today.

The project that I am working with is an ASP application using an Oracle database as one of its backends. Both IIS and the Oracle database are on servers outside my immediate network and of course there is no documentation. I can probably ask to have the appropriate tools loaded on either machine. The first thing that I need to do is to really inspect the database so that I have some idea what I am working with and the second is to upload the information from the spreadsheet. From a quick glance it looks like HTMLDB would allow me to do both And over the Web which would be great.

If I cann't use HTMLDB what tool would you recommend for these purposes?

again thanks,
Demetrius

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:lI6dnbPlX9ShgvPfRVn-ig_at_comcast.com...
>
> "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 - 14:27:35 CEST