National Instruments BridgeVIEW Using Microsoft Excel with Citadel

Appendix B Citadel and Open Database Connectivity

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 Using

Microsoft Query with Citadel 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.