Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Oracle data to excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Oracle data to excel
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Data from Oracle to Excel | Excel Discussion (Misc queries) | |||
Excel data upload to Oracle | Excel Discussion (Misc queries) | |||
Excel data upload to Oracle | Excel Discussion (Misc queries) | |||
Loading data from Excel to Oracle | New Users to Excel | |||
Exporting Excel data to Oracle DB | Excel Discussion (Misc queries) |