Assuming this is something you are going to do repeatedly, There are three ways I have done this. The first is use a SQL statement that creates the correctly formatted string for each record,
SELECT '"'|| char_column|| '",'|| char_column2|| (or cast some other data type into a char or varchar '"' FROM table
You can run this in SQL Assistant (and export it), Fast Export or BTEQ. The other way is to use OLE_LOAD to setup an export to a set of files that act like tables using the Jet driver. See the Microsoft site on how to do that. It can take a bit of time to get right, but it does do the job. Lastly, for really complex jobs, write a quick program and use the .NET provider or ODBC provider.