开发者

Read in a txt file using sqlcmd?

开发者 https://www.devze.com 2023-02-26 23:48 出处:网络
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

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消