SQL output

Is there a mechanism for SELECTing data and then writing that data to a file? Is the mechanism implementation specific? Can it be done with a parameter to specify the file name and location? Preferred database is access.