|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
How to: Populate Worksheets with Data from a Database
The features in this topic are available only if you have the required applications installed.
For more information, see.
Data access works the same way in Microsoft Visual Studio 2005 Tools for the Microsoft Office System projects as it does in Windows Forms projects. You use the same tools and code to bring the data into your solution, and you can even use Windows Forms controls to display the data. In addition, you can take advantage of controls called host controls, native objects in Microsoft Office Excel 2003 that have been enhanced with events and data binding capability. For more information, see.
To populate a worksheet with data from a database
Open your Excel application in Visual Studio, with the worksheet open in the designer.
Open the Data Sources window and create a data source for your project. For more information, see.
Drag the table or field you want from the Data Sources window to your worksheet. By default, acontrol is created on the worksheet for each individual field, and a control is created for each data range that includes multiple rows and columns. You can change this default by selecting the table or field in the Data Sources window and then choosing a different control from the drop-down list.
When you run the project, the controls display the first record in the data source. You can enable scrolling through the records by handling events using the objects in the.