by T.Hovila (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (7 Votes)
This code will take data from the Northwind database and write it to an Excel spreadsheet. Code can be modified to do more complex reports, but the basics are included here.
Assumes
You have a System DSN entry set up pointing the the Northwind database called nwind. You also need to set up references to Microsoft Excel 8.0 Object Library and Microsoft ActiveX Data Objects 2.1 Library.
Download VB to Excel (501 KB)