There's not enough information in your question for me to answer the question completely. However, to get started, I'd strongly suggest you look at Visual Basic for Applications (VBA), which is part of Microsoft Excel. You can access all the data components you need through Oracle's OLEDB drivers so you can do all the data manipulations you could ever want.
Related Q&A from John Robbins
What is a JAD session? This term is referred to often in job postings and seems like some kind of brainstorm you carry out with a client to define IT...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.