Re: Oracle to Excel? How?

In article <dtb.730518319_at_otto> dtb_at_otto.bf.rmit.oz.au 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)
>Senior Tech Consultant | Phone: +61 3 347-7511 TZ=AEST-10AEDST-11
>Global Technology Group | 179 Grattan St, Carlton, Vic, 3153, AUSTRALIA
>"The robber of your free will does not exist" - Epictetus
>--
>David T. Bath | Email:dtb_at_otto.bf.rmit.oz.au (131.170.40.10)
>Senior Tech Consultant | Phone: +61 3 347-7511 TZ=AEST-10AEDST-11
>Global Technology Group | 179 Grattan St, Carlton, Vic, 3153, AUSTRALIA
>"The robber of your free will does not exist" - Epictetus

You can use the Q+E that comes with Excel by opening a DDE channel and executing Q+E commands over the link. This is fairly well documented in the manuals that come with Excel.

That particular version of Q+E is NOT, however, the same as the currently-available "retail version" -- it is based on an earlier version of Q+E for which Microsoft obtained a source license and distribution rights. It is buggy and suited only for relatively simple applications (as I found out in implementing a major project).

If you have a large project, you might want to contact Pioneer Software (the originators of Q+E) and look into either the "retail version" or another related produce called Q+E Database Library which gives much more functionality.

There is no (practical) way you can access SQL*Net directly from Excel. If you don't like Pioneer's packages, there are others available now and ORACLE Glue should be out Real Soon Now.

Good luck!

-- 
Bill Meahan			|EFHD Information Systems Staff
Plant Floor Systems Specialist	|Ford Motor Company
wwm_at_ef5003.efhd.ford.com      	| +1 313 487 6122
..!fmsrl7!pmsmam!wwm           |I'm not paid to speak for Ford!