Multiple Select statements

• 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.