Export 2 queries to 1 csv (columns not the same) (1 Viewer)
- Thread starter anski
- Start date
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.
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.
- Local time
- Today, 10:50
- Joined
- Feb 19, 2002
- Messages
- 43,200
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.
The post processing will be using flat file I/O so you have to read one file and output the updated file.
- Local time
- Today, 10:50
- Joined
- Feb 19, 2002
- Messages
- 43,200
Clearly we have a different understanding of what that means.
