请教,从SQLSERVER中导出表到ACCESS中 请教,从SQLSERVER表中导出大量数据到ACCESS表中(表名相同,表结构也相同),怎么做才能快一点,我是先从SQLSERVER中读出,然后再一条一条写入ACCESS表中,太慢了,一万条数据要一分钟,十万条数据要十多分钟,太慢了。请问有什么方法能快点吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用delphi中的batchmove控件(BDE面板中)﹕可連兩個數據源(一個是SQLSERVER表﹐一個ACCESS表)﹕設定好參數后﹐BatchMove1.Execute; 我没有用BDE,用的是ADO,所以用不了batchmove控件 http://www.csdn.net/develop/article/18/18623.shtm http://www.csdn.net/develop/article/18/18623.shtm 为什么这条语句在SQL Server客户机不能执行。exec master.dbo.xp_cmdshell 'bcp "select * from sg_sales.dbo.id08 order by ccode" queryout "f:\aaa.xls" -S"server" -U"fz11" -P"c0a8a801"'提示:output ---------------------------------------------------------------------------------usage: bcp {dbtable | query} {in | out | queryout | format} datafile [-m maxerrors] [-f formatfile] [-e errfile] [-F firstrow] [-L lastrow] [-b batchsize] [-n native type] [-c character type] [-w wide character type] [-N keep non-text native] [-6 6x file format] [-q quoted identifier] [-C code page specifier] [-t field terminator] [-r row terminator] [-i inputfile] [-o outfile] [-a packetsize] [-S server name] [-U username] [-P password] [-T trusted connection] [-v version] [-R regional enable] [-k keep null values] [-E keep identity values] [-h "load hints"](11 row(s) affected) indy+多线程+数据库,莫名死掉…… 串口取数时,一般十六进制转换为指数的形式是什么样的? 请问怎么对oracle空间数据表的字段名和字段类型? 一个简单的,有意思的关于网络速度与程序速度的问题 两个小问题,请求帮忙! 不爽..散分...2 十万火急,高手请进,能搞定马上两边给分: 一个轻量级问题,程序运行起来正常,但数据录入时输错了日期格式死机。只能是1980-08-08格式否则程序死锁该怎么办? VC6.0和VC.net有什么区别? 求助求助 大家计论一下三层的事务控制问题,三层高手请进!! 请详细叙述一下如何跟踪sql语句,100分相送
exec master.dbo.xp_cmdshell 'bcp "select * from sg_sales.dbo.id08 order by ccode"
queryout "f:\aaa.xls" -S"server" -U"fz11" -P"c0a8a801"'提示:
output ---------------------------------------------------------------------------------usage: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n native type] [-c character type] [-w wide character type]
[-N keep non-text native] [-6 6x file format] [-q quoted identifier]
[-C code page specifier] [-t field terminator] [-r row terminator]
[-i inputfile] [-o outfile] [-a packetsize]
[-S server name] [-U username] [-P password]
[-T trusted connection] [-v version] [-R regional enable]
[-k keep null values] [-E keep identity values]
[-h "load hints"](11 row(s) affected)