Risk Cube between Excel and Access
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? Or is there any way to simply create a way so that whenever I cycle through the reports it will give me the corresponding cube? I know there are some simple workarounds but my issue is that I need everything to be connected so that if an update or change occurs on one, it gets mirrored on the other. Thank you for any help! Let me know if it's I made it too confusing.
|