Often when migrating data between databases, data is held in various formats. You can use Excel's custom formatting to quickly format cells so that they are simple to understand for the target system.

Want to find all entries in the database that aren't in the result of another query?

I’ve found it useful to seperate the code to run ADO recordset queries into a function. The benefit of this approach is that you can pass any SQL query as a string, and you will get back the recordset, and you can do whatever you want with it. Connection details are handled seperately and in the case of most Excel workbooks, can be hard coded into the workbook as a global constant (in this casemsConnectionString).