Best way to link between Excel and Access (Excel as Dashboard)
Posted on 2011-02-24
I'm creating a report which presents the data in Excel 2007 (mostly by pivot tables) which are linked to various Access queries and tables.
I was wondering, in terms of speed, memory and performance of the Excel reports:
1) Is it better to run off all queries in Access and just connect Excel to Access tables (or queries)
2)Is it better to bring everything into Excel and then amend the connection string in Excel and/or filter via pivot table filters.
Essentially what I'm doing is producing the same data/MI but cutting it for different users hence the filters, queries etc.