Microsoft Office Tutorials and References
In Depth Information
Tip 68: Importing a Text File into a Worksheet Range
8. Here, 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 68-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 68-2: This range contains data imported directly from a CSV file.