In Access 97 and XP you can use the File --> Export command. In 97 it
says something like Save As/Export. It opens the common dialog, you
navigate to the place you want the Excel file, name it, and click
Export. If you want to keep the query formatting (column widths and
such) make sure the Save Formatting box is checked before you export.
js********@aol.com (JSand42737) wrote in message news:<20***************************@mb-m22.aol.com>...
In article <bt**********@korweta.task.gda.pl>, "wojtekW" <wo******@op.pl>
writes:
I would like to export a result of query to Excel sheet. Mayby somebody
from you know how to do this?
Thanks
Wojciech Wasikiewicz
If the query can simply go into Excel "as is" with no special formatting then
you can use DoCmd.TransferSpreadsheet. Otherwise, you will need to use
automation to "push" the data into Excel.