Accessing Excel Data

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 ZOTO Received on Mon Jul 02 2001 - 06:59:23 CEST