不看会后悔的Windows XP之经验谈	简单快捷DIY实用家庭影院

导出Excel的问题，请大家帮帮手!

楼主dhtkhnt（龙卷风）2004-11-03 19:43:11 在 .NET技术 / C# 提问

导出Excel的时候出现了因字段内容太长而导出失败的问题，为什么呢？
如下这句导出是正确的:
"insert into [Sheet1$] (书名, 作者, 出版社, 图书简介, 书价) values ('sasdasdfas','asaaaaaaaa','asdfasdfas','asdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdf\r\n','0')"

如下这句却要出错了：
"insert into [Sheet1$] (书名, 作者, 出版社, 图书简介, 书价) values ('sasdasdfas','asaaaaaaaa','asdfasdfas','asdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdf\r\asdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdf\r\nasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfsdfasdfasdfasdfasdfasdfasdfasdf\r\n','0')" 问题点数：50、回复次数：14Top

1 楼dhtkhnt（龙卷风）回复于 2004-11-04 09:37:32 得分 0

问题应该比较简单吧! 顶Top

2 楼cedar_bj（兔子）回复于 2004-11-04 09:37:56 得分 5

upTop

3 楼dhtkhnt（龙卷风）回复于 2004-11-04 10:18:17 得分 0

再顶!Top

4 楼dhtkhnt（龙卷风）回复于 2004-11-04 14:06:56 得分 0

无人会吗？高手快来!Top

5 楼xiaoslong（龙哥）回复于 2004-11-04 14:59:30 得分 5

帮你顶一下
Top

6 楼dhtkhnt（龙卷风）回复于 2004-11-05 09:38:43 得分 0

帮顶者有分! 谢了!Top

7 楼davidyoung821（随云）回复于 2004-11-05 09:57:42 得分 5

不懂，顶Top

8 楼taozeng（入神）回复于 2004-11-05 10:01:41 得分 25

SQL语句有长度限制，超过长度则会报错。

你可以先定义一个变量

string bookdesc="超长字符"

再执行语句
"insert into [Sheet1$] (书名, 作者, 出版社, 图书简介, 书价) values ('sasdasdfas','asaaaaaaaa','asdfasdfas','"+bookdesc+"','0')"Top

9 楼dhtkhnt（龙卷风）回复于 2004-11-05 10:14:17 得分 0

用变量的方法我试过了，也是一样的错哦！好像是excel工作表"Sheet1"的"图书简介"列长度不够引起的. 还有其他解决的办法吗？Top

10 楼zhizhubao（至猪宝）回复于 2004-11-05 11:19:04 得分 5

路过，帮顶Top

11 楼wxy2004（）回复于 2004-11-05 11:29:22 得分 5

UPTop

12 楼dhtkhnt（龙卷风）回复于 2004-11-05 14:45:01 得分 0

UPTop

13 楼dhtkhnt（龙卷风）回复于 2004-11-05 16:04:34 得分 0

自己解决了! 谢谢大家的捧场！结贴!Top

14 楼dhtkhnt（龙卷风）回复于 2004-11-05 16:10:14 得分 0

怎么结贴变了!Top