export pivot table

[jk]

I am working with access 2003 and need to export a pivot table from one of my
query. I see the option as form and i also see it in pivot table view from
the query to export to excel.Can it be done automatically?