Generate a downloadable file from database (1 Viewer)

I have a database located on my server. If am able to display the records of a table through ASP. What im trying to do is use ASP to query a table and filter it, then have some sort of file which can be generated to download with all the filtered data in it e.g. csv file

Any ideas would be appreciated

Reptar