>thanks, I saw that solution after putting out the query, but then I find that one of my fields is a ZIP code with a leading 0, and using type csv drops the leading 0 once the csv file is imported into excel.
>Suggestions?
Use automation then using ADO. Search for ADO,Excel keywords, posted code recently.
Cetin