Read in a txt file using sqlcmd?

Is it possible to read in a txt file using sqlcmd, to avoid needing to type every cell by hand?

I've been given a txt file with every table row on one line, and every column seperated by a comma. (a .cvs file)

I've b开发者_运维技巧een trying to look up some commands but ... no luck!

Any and all help would be greatly appreciated!

As requested: http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/

You can use Management Studio to import the data in the file into a table.