Microsoft Office Tutorials and References
In Depth Information
Figure 16-3: Using the Import Data dialog box to import a CSV file at a particular location.
6. In the Import Data dialog box, click the Properties button to display the External Data Range Properties dia-
log box.
7. In the External Data Range Properties dialog box, deselect the Save Query Definition check box and click
OK to return to the Import Data dialog box.
8. In the Import Data dialog box, specify the location for the imported data. (It can be a cell in an existing
worksheet or a new worksheet.)
9. Click OK, and Excel imports the data (see Figure 16-4).
You can ignore Step 7 if the data you're importing will be changing. By saving the query
definition, you can quickly update the imported data by right-clicking any cell in the
range and choosing Refresh Data.
Search JabSto ::




Custom Search