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?

If not, this tutorial will be pleasantly surprising for you. In this article, we are going to show you how you can convert a CSV file to an Excel workbook. For that, we will be using a VBScript.