sql to access, export to excel - change field names only on excel output

downat420 · June 5th, 2009, 02:01 PM

I have an access front end to an SQL database. One of its features is exporting data to excel for our excel lovers. The problem is, the SQL row headings are not named very friendly. I want to export the data and rename to headings (only change the headings in excel).

an example:

SQL column heading: dip_temp_t1000x

in excel I would like that column header to read: Dip Temp

How can I accomplish this?

downat420 · June 5th, 2009, 04:04 PM

I should add:

If I right click --> export the form to excel it works as I want it to. But if I create a macro to export the form the headings are the SQL field names and that is not what I want.

I am not sure why it would export differently.

downat420 · June 8th, 2009, 11:08 AM

The problem was I was outputting to a query. I know this was not web based, and this is webforumz but I thought I would try. If I output to a form in the access macro it works as it should.

Dubbs · June 9th, 2009, 04:31 PM

Dowant420, I don't have Access or Excel to check if this works but maybe this will help you out some.

http://www.databasedev.co.uk/export-macro.html