Hi,
So I recently exported a bunch of data from an old online database
into Excel. Using this data I used a couple VLookups, Drop down menus and most
importantly some simple VBA code to create a Risk cube. My problem now is that I
need to transfer all of this into Access in order to make reports. So far I
successfully imported all of the data into Access but I have hit a snag with the
Risk cube. I created a form with the necessary fields but it is lacking the
cube. Is there any way to transfer the Risk cube (in it's working status) from
Excel to Access? Here are the criteria I need the cube to follow:
1) The Risk Cube must contain three series (Initial, Current, and Target)
2) Each Series has the coordinates based off of their respective Consequence and Probability
3) I want to include this in a report so I need it to work for every individual risk.
4) I need this to be tied to my existing Query so that it will update with any changes.
I have had a couple ideas of how to approach this but I don't know how to go about any of them.
1) Figure out a way to export the working Risk Cube with all parts working (doubtful)
2) Create the graph in Excel, without any data. Export this graph to Access and attempt to populate the graph with the data from the Query I made. (Most likely)
3) Or Figure out a way to do everything in Access.
These seem to be my options as of right now. I welcome openly any other suggestions. Please help, I am so stuck here.