[AccessD] Exporting Using Code

To all,
I have the following code to export a query into an excel sheet:
strSQL = "SELECT * INTO " & _
               "[Excel 8.0; Database=C:\Email\ProgrammeSummary.xls].” &  _ “[ProgrammeSummary] " & _
                "FROM qryProgrammeSummary "
Does anyone know if I can use the same method to export to a text file, if so could someone show me the syntax to it, cause I have been playing around with this for the last hour, and can’t seem to do it.
 
Thanks in advance for any help.
 
Paul Hartland

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm