Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 176
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Data from Oracle to Excel ram_guru Excel Discussion (Misc queries) 1 June 5th 08 04:41 PM
Excel data upload to Oracle Brent Excel Discussion (Misc queries) 0 March 8th 07 08:01 PM
Excel data upload to Oracle Jim Thomlinson Excel Discussion (Misc queries) 0 March 8th 07 07:39 PM
Loading data from Excel to Oracle Dr Sanjay New Users to Excel 1 May 26th 06 03:06 PM
Exporting Excel data to Oracle DB JBruxer Excel Discussion (Misc queries) 0 January 5th 06 08:40 PM


All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"