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?

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

can I create a macro to do this task?

Yep, use the transferspreadsheet action

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