macro refesh

eddieque · Mar 1st, 2002, 09:27 AM

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 · Mar 1st, 2002, 09:16 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 09:27 AM	#1
eddieque New Member Join Date: Feb 2002 Posts: 26	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 ?

Mar 1st, 2002, 09:16 PM	#2
Ziggy Board Regular Join Date: Feb 2002 Location: Ontario, Canada Posts: 326	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