Import a Query : Database Query « Collaboration « Microsoft Office Excel 2007 Tutorial






Click the Data tab. 
           Click the Existing Connections button.
Click the Data tab. Click the Existing Connections button.
Click the Web query. Click Open.
Click the Web query. Click Open.
Click the Existing worksheet option and specify a cell location.
Click the Existing worksheet option and specify a cell location.
To refresh the query data, click the Refresh All button arrow, 
           and then click Refresh.
To refresh the query data, click the Refresh All button arrow, and then click Refresh.








13.5.Database Query
13.5.1.Define a New Data SourceDefine a New Data Source
13.5.2.Create a Database QueryCreate a Database Query
13.5.3.Import a QueryImport a Query