Re: Accessing Excel Data

<posted and emailed>

I would use perl and it's ability to communicate with Excel and Oracle. I do this for my reporting system at work Email me for more details if you are interested

John
Zoltan <zoto29_at_hotmail.com> wrote in message news: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
>
> ZOTO
Received on Sun Jul 08 2001 - 04:00:36 CEST