[VIEWED 3592
TIMES]
|
SAVE! for ease of future access.
|
|
|
gitanjali
Please log in to subscribe to gitanjali's postings.
Posted on 08-06-07 7:01
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
It may be very simple question for SAJHA IT GURUS How Oracle data from datawarehouse can be reported in Crystal, Excel, and MS Access interfaces? Any standard SQL statement for importing and exporting data in and out from datawarehouse? Thanks in advance for your help
|
|
|
|
rajeshHamal
Please log in to subscribe to rajeshHamal's postings.
Posted on 08-06-07 11:24
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Search for ADO (activex data object). With minimal effort, a.k.a. cut-and-paste, I was able to bring Oracle database into Excel using ADO code in VBA. Others might give better guidance. I am not an IT guy.
|
|
|
gitanjali
Please log in to subscribe to gitanjali's postings.
Posted on 08-07-07 1:26
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Thanks rajeshHamal.Any other thought.
|
|
|
rajeshHamal
Please log in to subscribe to rajeshHamal's postings.
Posted on 08-07-07 7:50
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
CAN u elaborate a little about your level? Do you know any VBA or VB? Or are you just a database user without any programming experience? Your answer might help others choose appropriate direction to show you. Thanks
|
|