The ability to automate tasks in Excel for the web has been a long wait—but it’s finally here, and it was worth the wait.

I need to be able to run a vbscript at night to export the contents of an Access DB to an Excel spreadsheet. Any suggestions how to do this?