I have an Access DB with various forms. Because of the way the headers and footers are, it seems hard to export all the information.
So, I'm trying the other way around and getting Excel to retrieve the data.
The problem is that not all data can be retrieved through a query. Various cells will have to be calculated from different tables in the DB, etc.
Is there a way to do this in Excel or does it all have to be query based?