Filemodewill be changed to
Appendafter 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.