[!INCLUDE sqlserver-ssis] [!INCLUDE ssISnoversion] provides the Excel connection manager, Excel source, and Excel destination for working with data stored in spreadsheets in the [!INCLUDE msCoName] ...

I don't know anything about "Declare Function"; these are just added via Tools | References in the Excel VBA editor, and then they're added to the libraries listed in the Object Browser, and ...

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?