I don't disagree. As with everything to do with databases and VBA it depends on the number of records involved.
If the sample is representative then do as you like.
If lots of records are being exported from 2 tables in unison then using built in functionality would probably be faster even if it needs some post processing.