Bulk importing CSV to SQL Server on a remote command line

Simple bulk insert from the command line to import a csv

SQLCMD -E -S myserver\myinstance -Q "BULK INSERT myDatabase.dbo.myTable FROM 'C:\rdbms_local_path\myFile.csv' WITH(FIELDTERMINATOR=',', ROWTERMINATOR='\n')"