This code is attached to a command button in an Access database that our employees use... I have written a ton of code to format the sheet and color format the rows after the data is moved into an excel sheet. This code worked fine before as .adp I really need to figure out how to get it right now that its .accdb. I really think it goes back to as a .adp file the database linked to sql server and now that its a .accdb file the tables are linked once you open the database.

This has to be common... I'm sure people use vba to transfer results from an SQL Server View to an.xlsx sheet all the time. I don't why I've had so much trouble finding out how to code this. I don't think acOutputQuery works at all in the .accdb format.