T
thehallclan
Guest
Help! How Can I ODBC Link a Union Query to Excel?
I do a lot of apps where I perform all of the analysis in Access and then refresh the results into Excel via an ODBC connection. I use it for Pivot Tables/Charts etc. I have found that I can not use a Union Query for this purpose. Is there some way to get around this limitation? I understand that I can make a table or something like that, but I really want to have it where the user can open an Excel spreadsheet and the spreadsheet is refreshed automatically without them even seeing the Access back end. Any help would be greatly appreciated.
I do a lot of apps where I perform all of the analysis in Access and then refresh the results into Excel via an ODBC connection. I use it for Pivot Tables/Charts etc. I have found that I can not use a Union Query for this purpose. Is there some way to get around this limitation? I understand that I can make a table or something like that, but I really want to have it where the user can open an Excel spreadsheet and the spreadsheet is refreshed automatically without them even seeing the Access back end. Any help would be greatly appreciated.
Last edited:
