Axel - Combining Access and Excel into 1 excellent product
I have been developing with Access and Excel for the last 17 years, it is my bread and butter and while I use VBA to communicate between the two I had the following thought...
Wouldn't it be great if a new product came to market that contained both Access and Excel objects?
Viewing Form tabs alongside Excel Worksheets in the same development window, showing sheets as objects in the same pane as tables and queries etc.
A benefit of both data storage and calculations plus it would certainly be faster.
You could call it Excess or Axel
It would sell like hotcakes.
While we won’t be merging Excel and Access into a single product, we have been doing a lot of work in Excel to make it work better with data. Power Pivot, Power Query, and the Data Model are all tools that let you pull data from multiple sources, join and manipulate that data, and then do all of the ad-hoc reporting on it that you are used to doing in Excel.