From DAO to ADO: Exporting an SQL results query to Excel (1 Viewer)

Our Access database software is being updated from 2010 to 2013. My understanding is that DAO is no longer supported in 2013. I have some code that runs an SQL query from a form button in 2010 and exports the result as an Excel file, using DAO.

I would be grateful if anyone here could provide a working example of the equivalent using ADO?

mackyrm said:

My understanding is that DAO is no longer supported in 2013.

Click to expand...

I do believe your understanding is mistaken ?