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.
精彩评论