If you have multiple select statements you only need to code one Export statement. The specified options will apply at all subsequent select statements; except that Filemode
will be changed to Append
after the first statement has been processed. The result will be that the data from all the select statements will be appended to the same file.
If you have multiple statements, and are writing to Excel, then a slightly different rule applies. If you code a Worksheet name, all the data will be written to this Worksheet. If you do not specify a Worksheet, every set of data will be written to a different Worksheet.