Appendix B
Citadel and Open Database Connectivity
©
National Instruments Corporation
B-11
Using Microsoft Excel with Citadel
Note
The exact operation of Microsoft Excel might change from version to version.
Look in the online help for Microsoft Excel for how to connect to an ODBC Data
Source for the exact instructions for your version of Microsoft Excel.
To extract data from Citadel, activate Excel and choose
Data»Get
External Data…. This Excel command directly activates Microsoft Query.
From here you can use an existing query or create a new one. See the
section.
When you finish building your query, return the result set by choosing
File»Return Data to Microsoft Excel…
Excel responds by presenting
the Get External Data dialog box, enabling you to change or confirm the
destination cells of the result set. If you want to update the result set later
by requerying Citadel, be sure that Keep Query Definition remains
selected. Choose OK to write the data into the Excel worksheet.
To update your result set, select any cell within the worksheet’s result set,
choose
Data»Get External Data…, and click the Refresh button.