From: gjlinker@oraxcel.com (Gerrit-Jan Linker)
Newsgroups: comp.databases.oracle
Subject: Re: Accessing Excel Data
Date: 7 Jul 2001 12:34:25 -0700
Organization: http://groups.google.com/
Lines: 15
Message-ID: <774a64cd.0107071134.1e81d6e9@posting.google.com>
References: <8f64800e.0107012059.4fa50a96@posting.google.com>
NNTP-Posting-Host: 213.123.141.32
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 994534466 22953 127.0.0.1 (7 Jul 2001 19:34:26 GMT)
X-Complaints-To: groups-support@google.com
NNTP-Posting-Date: 7 Jul 2001 19:34:26 GMT


Hello,

SQL*XL may be the tool you may be looking for here. SQL*XL can batch
upload a whole spreadsheet full of data into an Oracle database. So
that takes care of getting the data into a real database.
Furthermore, SQL*XL is great for ad-hoc queries. It pulls the data you
want out of Oracle and puts it into your current spreadsheet. Quite
nice because in Excel you can then use the data for printing,
calculations, etc.

Have a look at SQL*XL at www.oraxcel.com

Hope this helps,

Gerrit-Jan Linker