Accessing Citadel 4 Data with Microsoft Excel
Print- Launch Excel.
- Choose Data»Get External Data»Create New Query. This Excel command directly launches Microsoft Query.
- Use an existing query or create a new one.
For help with Query refer to: Accessing Citadel Data from Microsoft Query - When you finish building your query, return the result set with the File»Return Data to Microsoft Excel command. Excel prompts you with the Get External Data dialog box, enabling you to change or confirm the destination cells of the result set. If you want to query Citadel later to update the result set, check the Keep Query Definition checkbox.
- Click on OK to write the data to an Excel worksheet.
- To update your result set, select any cell within the worksheet result set, choose Data»Get External Data, and click on the Refresh button.
Related Links:
Accessing Citadel Data from Microsoft Query
Reader Comments | Submit a comment »
Legal
This tutorial (this "tutorial") was developed by National Instruments ("NI"). Although technical support of this tutorial may be made available by National Instruments, the content in this tutorial may not be completely tested and verified, and NI does not guarantee its quality in any way or that NI will continue to support this content with each new revision of related products and drivers. THIS TUTORIAL IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND AND SUBJECT TO CERTAIN RESTRICTIONS AS MORE SPECIFICALLY SET FORTH IN NI.COM'S TERMS OF USE (http://ni.com/legal/termsofuse/unitedstates/us/).