We are in the process of converting our Crystal reports to Excel. We plan to download raw data from Oracle to a tab in a spreadsheet. The name of this tab will be "Data". My questions are related to how I can treat this "Data" tab as the data source to my spreadsheet without using ADO or any other driver that does not come stock with Excel (since this spreadsheet will ultimately be used by clients having varying desktop configurations).
Essentially I'd like to be able to process the data in the "Data" tab, group it, sort it, calculate on it and create charts / graphs from it.
The first thing I need to figure out is how to treat the "Data" tab as the data source to my spreadsheet so that I may populate other tabs with formatted report output.
Thanks, Mike.
Essentially I'd like to be able to process the data in the "Data" tab, group it, sort it, calculate on it and create charts / graphs from it.
The first thing I need to figure out is how to treat the "Data" tab as the data source to my spreadsheet so that I may populate other tabs with formatted report output.
Thanks, Mike.