I haven't tried any VB-related code in a quite a while, so ignore me if you already tried this 🙂 But two pieces I would investigate are whether your columns can insert nulls and whether you insert the data before you update.

In your main select command, you've got ISNULL transformations on most columns (not all returning an alternate field if null), so some like the COMMENTS column probably are null if these data elements are not required. If you're inserting these into your Excel, that's probably not the issue.

Other than that, I noticed your INSERT statement up top but I didn't see where you called that. You reference that insert statement near the end of your code and assign it to a command but the recordset is called with the update function.