22,210
社区成员
发帖
与我相关
我的任务
分享
10.0
33
1 SQLCHAR 0 0 "," 1 Name Chinese_PRC_CI_AS
2 SQLCHAR 0 0 "," 2 CardNo Chinese_PRC_CI_AS
3 SQLCHAR 0 0 "," 3 Descriot Chinese_PRC_CI_AS
4 SQLCHAR 0 0 "," 4 CtfTp Chinese_PRC_CI_AS
5 SQLCHAR 0 0 "," 5 CtfId Chinese_PRC_CI_AS
6 SQLCHAR 0 0 "," 6 Gender Chinese_PRC_CI_AS
7 SQLCHAR 0 0 "," 7 Birthday Chinese_PRC_CI_AS
8 SQLCHAR 0 0 "," 8 Address Chinese_PRC_CI_AS
9 SQLCHAR 0 0 "," 9 Zip Chinese_PRC_CI_AS
10 SQLCHAR 0 0 "," 10 Dirty Chinese_PRC_CI_AS
11 SQLCHAR 0 0 "," 11 District1 Chinese_PRC_CI_AS
12 SQLCHAR 0 0 "," 12 District2 Chinese_PRC_CI_AS
13 SQLCHAR 0 0 "," 13 District3 Chinese_PRC_CI_AS
14 SQLCHAR 0 0 "," 14 District4 Chinese_PRC_CI_AS
15 SQLCHAR 0 0 "," 15 District5 Chinese_PRC_CI_AS
16 SQLCHAR 0 0 "," 16 District6 Chinese_PRC_CI_AS
17 SQLCHAR 0 0 "," 17 FirstNm Chinese_PRC_CI_AS
18 SQLCHAR 0 0 "," 18 LastNm Chinese_PRC_CI_AS
19 SQLCHAR 0 0 "," 19 Duty Chinese_PRC_CI_AS
20 SQLCHAR 0 0 "," 20 Mobile Chinese_PRC_CI_AS
21 SQLCHAR 0 0 "," 21 Tel Chinese_PRC_CI_AS
22 SQLCHAR 0 0 "," 22 Fax Chinese_PRC_CI_AS
23 SQLCHAR 0 0 "," 23 EMail Chinese_PRC_CI_AS
24 SQLCHAR 0 0 "," 24 Nation Chinese_PRC_CI_AS
25 SQLCHAR 0 0 "," 25 Taste Chinese_PRC_CI_AS
26 SQLCHAR 0 0 "," 26 Education Chinese_PRC_CI_AS
27 SQLCHAR 0 0 "," 27 Company Chinese_PRC_CI_AS
28 SQLCHAR 0 0 "," 28 CTel Chinese_PRC_CI_AS
29 SQLCHAR 0 0 "," 29 CAddress Chinese_PRC_CI_AS
30 SQLCHAR 0 0 "," 30 CZip Chinese_PRC_CI_AS
31 SQLCHAR 0 0 "," 31 Family Chinese_PRC_CI_AS
32 SQLCHAR 0 0 "," 32 Version Chinese_PRC_CI_AS
33 SQLCHAR 0 0 "\r\n" 33 id Chinese_PRC_CI_AS
select *
from
openrowset(bulk '你的文件路径.csv', --要读取的文件路径和名称
formatfile='E:\2000W开房csv格式\网络数据.fmt', --格式化文件的路径和名称
firstrow = 2, --要载入的第一行,由于第一行是标题,所以从2开始
--lastrow = 1000, --要载入的最后一行,此值必须大于firstrow
maxerrors = 10, --在加载失败之前加载操作中最大的错误数
--errorfile ='c:\wc_error1.txt', --存放错误的文件
rows_per_batch = 10000 --每个批处理导入的行数
) as t
--修改高级参数
sp_configure 'show advanced options',1
go
--允许即席分布式查询
sp_configure 'Ad Hoc Distributed Queries',1
go
--如果配置的值不在合理范围(在最小值最大值范围内),那么可以强制覆盖
reconfigure with override
go
sp_configure 'xp_cmdshell',1
go
reconfigure
go
--导出格式文件,这个是关键,数据库名称,表名称,用户名和密码,服务器ip和端口
--都改成你自己的
exec xp_cmdshell 'bcp 网络数据.dbo.KaiFanG_RJ format nul -t "," -f E:\2000W开房csv格式\网络数据.fmt -c -Usa -000000 -S local'
go
???没提示错误,然后呢?