macro refesh

[eddieque]

I am importing data from access 2000 into an excel 2000 spread sheet. I am getting the data there from data/get external data/run new query. I save the query.
I want to refresh the data. When this happens the column headings get changed from total sales to SUMOF total sales, which is the name inthe access data base. Even when i write a macro to handle the refresh and to change the column heading to total sales it still goes back to this SUMOF.
Anyway to prevent this or to get it to go back to total sales ?

 

[Ziggy]

It is much simpler to Export from Access to Excel.

Go to Macro's tab in Access click new. Then on the "Action" Line select "Transfer Spreadsheet"

In the Arguments below select Export, type in the name of your query( says table name)
and the Path to where you want to export to.

you can tie it in with a button on a form

Oh I always change those "Sum Of..." by going to the field in design view of query. right click field and select properties type in a name under Caption.

Ziggy