Accessing Excel Data
Date: 1 Jul 2001 21:59:23 -0700
Message-ID: <8f64800e.0107012059.4fa50a96_at_posting.google.com>
I would like to know what would be the best way to access data in an
MS Excel spreadsheet.
We would be receiving spreadsheets from a number of sources and they
would be updated with different revisions. We will only ever be
reading the Excel data, never writing to it.
On the surface it wouldseem that being able to run a query on the
Excel DB directly would be best since we would only need to overwrite
the obsolete DB with the current revision and Oracle would just go to
the new one.
This however may be a lot of work in writing a driver of some kind
(especially for a novice). Would it be easier to convert the Excel DB
to a delimited file and import the data into a table? How difficult
would it be to replace the table with updated data?
TIA