[Office automation] re-read "Let Excel Fly" (when importing Access data from Excel, Union union query, the data source does not contain a visible table)

More than a year ago bought @mrexcel's "Let Excel Fly" this book. The overall idea is to use Access combined with Excel to significantly improve data analysis efficiency.

Recently I took it out and looked at it. The 15th chapter, more "Advanced" than the advanced screening, P241. Mainly about multi-table association query, can be applied to one-to-many scenarios.

P248: Three types of join properties.

Union union queries can be used to implement multi-table data merging with the same table header.

But when you rewind the data back to Excel, you find that you always get an error.

The error message is as follows: The data source does not contain a visible table.

Later found the reasons and solutions are as follows:

With the visual Query Designer in Access, you can largely avoid Excel in Excel not directly importing "crosstab queries" and "union union queries" in Access.

The detour is to make a " select query " based on "crosstab query" and "Federated query", then import this "select query" in Excel to

More Impressions:

One, 15.4 data summary query, similar to the SUBTOTAL function.

Second, the reason to use Access, because of high efficiency, suitable for large data volume. See P241 for more reasons.

For more details, you can go to Dangdang to buy @mrexcel's genuine "Let Excel Fly"

[Office automation] re-read "Let Excel Fly" (when importing Access data from Excel, Union union query, the data source does not contain a visible table)