您使用的是Excel连接器，而不是csv连接器.
更好的尝试:

You are using an excel connector not a csv connector.
Better try:

select TerritoryID
      ,TotalSales
      ,TotalCost
from openrowset('MSDASQL'
               ,'Driver={Microsoft Access Text Driver (*.txt, *.csv)}'
               ,'select * from C:\myfileName.CSV')

可以在此处找到更多信息 [ ^ ].

more info can be found here[^].