What are the Limitations for Connecting to an Access Query in Excel
- by thornomad
I have an Access 2007 database that has a number of tables, some are fairly large (100,000+ records); I have created a union query to pull some of the same types of data from multiple tables into one large query for pivot table manipulation and reporting. For example:
SELECT Language
FROM Table1
UNION ALL SELECT Language
FROM Table2
UNION ALL…