Re: Oracle to Excel? How?

In article 730518319_at_otto, dtb_at_otto (David Bath) writes:
>I know Excel comes with Q&E that can hit Oracle tables.
>Does anyone know how to get the data from there into an Excel
>spreadsheet ? Preferaly using Excel macros? Or can I get
>the data straight into excel from SQL*Net ?
>
>David T. Bath | Email:dtb_at_otto.bf.rmit.oz.au (131.170.40.10)

This is an easy one - Q&E sets in between Excell and Oracle. You don't even notice it. There's a menu option in Excell that lets you query a database and put the results directly into your spreadsheet at whatever cell you are currently residing. It will even ask you if you want to maintain a "live" link to the database (which will result in changes that you make in your spreadsheet being propagated back to the database). I don't recommend that you use the live links because I suspect that they may lock up the database table while you are working in Excel (if they're smart they will just do an update when you save your spreadsheet, but of course then someone else's changes might get written over,...).

Regards,

Tom C

e-mail: connolly_at_udel.edu Received on Wed Feb 24 1993 - 18:47:40 CET