Tried that... but it only produces a .xl? file. I need to export the data as a .csv file format. In 2002, sorry to say that is where we are, you can develop the export/import spec while you are doing the export after you right clicked on the query. Is there a way to create a spec file that is...