Text Import

Text Import settings:

Note that there are additional settings not pictured here.

The resulting data in the grid:

The range is associated with a QueryTable object. This query table definition references the @connectionId used to retrieve the data.