The data is not a CSV file, but is a single column of data. Also, this
import is part of a macro which calls several macos to import additional data
and transform/manipulate the date once its in the template. I found that
this code works:
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:\Program Files\...\Estreslt.txt", Destination:=Range("A1"))
.Name = "Estreslt"