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

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.

Thanks rajeshHamal.Any other thought.

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