Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-20-2015, 12:35 PM
KingoftheKassel KingoftheKassel is offline Risk Cube between Excel and Access Windows 7 64bit Risk Cube between Excel and Access Office 2010 64bit
Novice
Risk Cube between Excel and Access
 
Join Date: Jul 2015
Posts: 5
KingoftheKassel is on a distinguished road
Default 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.
Reply With Quote
Reply

Tags
access 2010, risk cube



Similar Threads
Thread Thread Starter Forum Replies Last Post
Risk Cube between Excel and Access Tools or Assistance in Making a 3D Cube mredmond PowerPoint 4 09-24-2014 06:30 AM
Excel to Access to Excel for report automation Nicholaspoe Excel Programming 10 10-08-2013 08:13 PM
Portfolio Analyzer Cube - Cost Resource Question seanpears99 Project 2 03-07-2013 06:59 PM
Risk Cube between Excel and Access Should I uses Access or Excel? tinkertron Office 5 03-29-2009 08:30 PM
Excel or Access ? inferno Excel 0 10-03-2008 03:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft