Export 2 queries to 1 csv (columns not the same)

[MarkK]

Or late bound, use...

    With CreateObject("Scripting.FileSystemObject")

...instead of...

    With New Scripting.FileSystemObject

Mark

 

[static]

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.

 

[Pat Hartman]

Process a record once or process it three times?

The post processing will be using flat file I/O so you have to read one file and output the updated file.

 

[static]

You wouldn't be processing any records individually at all. That's the point. You would be BATCH processing.

 

[Pat Hartman]

You would be BATCH processing

Clearly we have a different understanding of what that means.

 

[static]

It does feel like I'm speaking a different language at times.