如何实现无组件上传到数据库？

[shearydeng83]

本身数据库里面有数据表，表里的字段格式已经定好了，我只是想把一些新的数据倒进去，例如是倒入1000条数据这样，这个可以用上传来实现吗？
请讲得详细点，其实我连无组件上传也不知怎么用哦~~

[shearydeng83]

dts?什么意思哦？不解！

[shearydeng83]

upup

[hdhmail2000]

dts

[hdhmail2000]

就是sql server用来导入数据的工具阿
data transformation services

[hdhmail2000]

不过不用定时执行的话，直接用bcp就可以了
Syntax
bcp {[[database_name.][owner].]{table_name | view_name} | "query"}
{in | out | queryout | format} data_file
[-m max_errors] [-f format_file] [-e err_file]
[-F first_row] [-L last_row] [-b batch_size]
[-n] [-c] [-w] [-N] [-V (60 | 65 | 70)] [-6]
[-q] [-C code_page] [-t field_term] [-r row_term]
[-i input_file] [-o output_file] [-a packet_size]
[-S server_name[\instance_name]] [-U login_id] [-P password]
[-T] [-v] [-R] [-k] [-E] [-h "hint [,...n]"]


For example, the Northwind database has the table Jane's Orders, which is owned by user Jane Doe. To bulk copy this table from the Northwind database to the Orders.txt file using the login Jane Doe and the password go dba, execute one of these commands:

bcp "Northwind.Jane Doe.Jane's Orders" out "Jane's Orders.txt" -c -q -U"Jane Doe" -P"go dba"

bcp "Northwind.[Jane Doe].[Jane's Orders]" out "Jane's Orders.txt" -c -U"Jane Doe" -P"go dba"

To specify a database name that contains a space or quotation mark, you must use the –q option.

[shearydeng83]

哗！！一点都睇唔明哦！！！什么东东来的？？

[hdhmail2000]

sql server的帮助啊，bcp导入数据
你也可以自己找来看看哦