I have a problem where I cannot export to Excel as 2010 max 65k rows on clipboard.
My alternative method of importing to Excel will not work on some Queries as they cannot be seen.
I have been importing the queries to Ecxel
My problem now comes that I have created a new query looking at two tables with some calculations in (NZ) call it QueryZ. I cannot see the queries in the list from the Excel Data transfer option.
The other Queries in the database can be seen OK.
If I create another Query off QueryZ this will not show either.