oracle into excel form/report

[BackStageJim]

Perhaps this is the wrong thread, but I’m losing my patients with Excel external data from Oracle.

I need to connect to Oracle to pull data from query and display the information in an Excel sheet that ‘looks’ like a report or single page from word mail merge. Now the query will return one row for each page that is reported. I was able to generate a ‘form’ in SHEET1, but when I try to link SHEET2 with query data, only the first row shows. What am I doing so wrong? Is there an example I’ve failed to find using various keyword searches?

 

[xlbo]

I would take exception at no.3 - if you really think that then you have not been properly exposed to exactly what you can do with excel

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question