I'm surprised at this article. Why doesn't anyone use the tried and true method that I've been using for over 20 years:

SELECT *

from opendatasource('Microsoft.ACE.OLEDB.12.0',

'Data Source=C:\Zipstuff\;Extended Properties="Text;HDR=YES"')...products#csv

While I'm using...