Hi again.
Remember, from the 1st part of this post, you have Sales, you have
Profit & Loss and, most important, you have a demanding boss! :)
We saw how we can easily retrieve CUBRID data
into Excel by using the OLE DB Driver
and writing some VBA macro
code. In this 2nd part of the blog post, we will not write any custom
code at all, but we will use only the built-in Excel OLE DB support to achieve similar results.
Btw, let's not forget what we said - "a picture is worth a thousand words"! So let’s try more images and less talk... :)
We will start by creating a CUBRID OLE DB connection from Excel:
Next, we will select the CUBRID View we
need to use to show the boss the Sales
data (see 1-st part of the post):
Once all these steps are completed, we have our data in
Excel:
All is left to do is to create the chart we need. One
easy way to achieve this is to select the “Pivot
chart” option, in the last step of the wizard:
Of course, you can go on "playing" further with the Sales
data – there are no limits - once you got the right data into Excel, you have so many ways to
display it…
And there is one last thing to clarify: how does the data gets refreshed? Well, it’s quite simple – take a look:
That’s it - See you
next time – Bye-bye! :)
P.S. Remember, there’s more
choices to get CUBRID data into Excel – for example, you can try to use as well
the CUBRID ODBC Driver.
