Bulk Insert is a fairly common function, but not so common that I can remember the syntax every time. Here I’ve posted the version I use most:
BULK INSERT dbo.TableName
Note that Bulk Insert does not support skipping headers. The source file should not include headers otherwise the load will fail.
More about Bulk Insert: