I'm developing a complicated predictive model program with Office 2000. There's so much data, it needs to be in Access (some tables have > 85000 rows), but some of the base tables require editing with Excel, because the end user wants to be able to use formulas to manipulate base data for each scenario.
Do I have to have the user open the linked Excel spreadsheet, make the edits for a particular scenario, then open the Access database and run the "compile scenario" macro in Access to do all the cross-tab queries formulas and such? Or does Excel have the capability to run all the make-table and other queries just using Access as a back-end?
Thanks for any insight!
Do I have to have the user open the linked Excel spreadsheet, make the edits for a particular scenario, then open the Access database and run the "compile scenario" macro in Access to do all the cross-tab queries formulas and such? Or does Excel have the capability to run all the make-table and other queries just using Access as a back-end?
Thanks for any insight!
