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[
^].