I have an excel workbook that generates business projections using a monte carlo simulation. I would like to save the simulations/projections into an access database so that actual performance can be tracked against expected performance.
Can this be achieved through a data connection with access, or does it have to be done using VBA?
Or even better, is there some third option that is cleaner than either of the two I've mentioned already?
I appreciate your responses ahead of time.
Can this be achieved through a data connection with access, or does it have to be done using VBA?
Or even better, is there some third option that is cleaner than either of the two I've mentioned already?
I appreciate your responses ahead of time.
