Writing to CSV file from access

[///M]

I have a basic access query at the moment. I am looking for a basic way to input the results of the query to a CSV file. Here is the code


SELECT [Clients].[Company Name], [Clients].[Full Name], [Clients].[Title], [Clients].[Post Code], [Clients].[Phone], [Clients].[Mobile], [Clients].[Email], [Clients].[Max Update]
FROM Clients
WHERE [Clients].[Max Update]=Yes;


Thanks

Allan

[Shuja Ali]

I haven't come across a direct method of writing to a file from query in Access. However if you are using a Front End and opening a recordset using this query then you can use something similar to this
http://www.vbforums.com/showthread.php?t=397330

[///M]

Dont seem to be able to get it to work :(

[Shuja Ali]

What is your front end?