Output to Excel 2000

[SteveGr]

I am having trouble outputting a table to Excel. Access automatically saves the excel file in the older 95 format. How can I save the outputted table to an Excel 2000 format?

 

[Hayley Baxter]

Choosing File, Export should give you the option of saving it as an Excel 97 -2000 format from the drop down type box.

 

[SteveGr]

can I create a macro to do this task?

 

[Hayley Baxter]

Yep, use the transferspreadsheet action

 

[SteveGr]

Thanks, I was mistakingly using "Output to" in my macro.