Microsoft Office Tutorials and References
In Depth Information
Importing a Text File into a Worksheet Range
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 175-2).
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.
Figure 175-2: This range contains data imported directly from a CSV file.
Search JabSto ::

Custom Search