Oracle data to excel
I don't know why I should repeat myself? BUT I actually wrote "I don't
want to use pivots" - I don't have to explain it to you - but I DO
NOT! very simpl isn't??
And why?
Because pivots is to fragile - I'm not the only user.
Perhaps it's because I'm not an superguruexpert, but.........
I'd spend enough time trying to get a grab on pivots and cubes.
e.g. IF there are no data in the database at a given time, it gives me
problems.
etc etc...
So I'd be glad IF one brain out there could give me some hints.
(no pivots - no cubes)
Best regards
Kim
"Bernie Deitrick" wrote in message ...
Kim,
I do not want to use pivots.
Why not - that's exactly what they are there for. So use a Pivot
Table, then convert the pivot table to values.
how do I do that i VBA?
Use Pivot Tables in VBA, or write a whole lot of code that replicates
using a pivot table. And you'll be the one writing it, 'cause it's a
waste of time otherwise.
HTH,
Bernie
"Kim" wrote in message
om...
Hi all
I want to retrieve data from an Oracle database
placing them in a sheet
in different columns
at present I use msquery and the result comes in 3 colums
with many rows, like this
time ID VALUE
2003.10.18 00:00 timeserie1 345
2003.10.18 01:00 timeserie1 567
.
.(24 timestamps for timeserie1)
.
2003.10.18 23:00 timeserie1 123
(new timeserie comes here)
2003.10.18 00:00 timeserie2 234
2003.10.18 01:00 timeserie2 345
.
.(24 timestamps for timeserie2)
a.s.o.
I want to have the result in a matrix
like this
[begin]
timeserie1 timeserie2 timeserie3
2003.10.18 00:00 123 456 999
2003.10.18 01:00 234 345 888
.
.
2003.10.18 23:00 111 763 434
[end]
this is the sql from msquery..
'SELECT VW_EXPORT_VIEW.DATAPOINT_NAME, VW_EXPORT_VIEW.TIMESTAMP,
VW_EXPORT_VIEW.VALUE, VW_EXPORT_VIEW.MESS_ID
'FROM BDATA_SYS.VW_EXPORT_VIEW VW_EXPORT_VIEW
'WHERE (VW_EXPORT_VIEW.TIMESTAMP{ts '2003-10-12 00:00:00'} And
VW_EXPORT_VIEW.TIMESTAMP<{ts '2003-10-13 00:00:00'}) AND
(VW_EXPORT_VIEW.MESS_ID In (5621,5622,5623,5593))
I do not want to use pivots.
how do I do that i VBA?
Cam one of you freindly poeple in here please help??
Best Regards
Kim
|