请问 OleDb 写入Excel数据源是不是不支持 INSERT INTO t1(f1,f2) VALUES(v1,v2),(v3,v4)...这种语句啊?

三国小将 2017-11-29 03:34:53
RT,
请问
OleDb 写入Excel数据源是不是不支持
INSERT INTO t1(field1,field2) VALUES(v101,v102),(v201,v202),(v301,v302),(v401,v402);
这种语句啊?
...全文
369 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
des_xue 2017-11-29
  • 打赏
  • 举报
回复
你试试插两组 INSERT INTO t1(field1,field2) VALUES(v101,v102),(v201,v202) 能不能成,能成就是你生成的SQL太长了
des_xue 2017-11-29
  • 打赏
  • 举报
回复
超长度截断了吧
三国小将 2017-11-29
  • 打赏
  • 举报
回复
sql语句是一个随机生成的63个字段的语句,如下: insert into [TestSheet$] (col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14,col15,col16,col17,col18,col19,col20,col21,col22,col23,col24,col25,col26,col27,col28,col29,col30,col31,col32,col33,col34,col35,col36,col37,col38,col39,col40,col41,col42,col43,col44,col45,col46,col47,col48,col49,col50,col51,col52,col53,col54,col55,col56,col57,col58,col59,col60,col61,col62,col63) values ('96fId5mKQwNSWywwDXcmmAnYS36ezCIBiMAIAi0gCvCF91RG','MkJZrffbOCpMffY','2xWxxkxA8R4HAbShiXxzJ45Ef','3dJhn9yp7','3pFnB7DmanDwqXIzZeRNjN8ag8X','6XmkjtfB7VcAuxoGfJeCI5y4Y964wz0Hw6x','NsSCbAfBUZIVUoBbCNM1Tv','i9pSEDUnw1LJ26ugBIidSk0dZvWZe7zSlmzDrNA','1avCGlClY','2pf01HMVL7wDd5v7fkWzqNB7dkCrnj','9tW50gpmTFi7RMrNkgI6zJwj4suDnX','gkc3nA1fO4LBULLp89lxGJs8o4w2G8b1P3ZT9BY','j2M2WZxbq30R','jVb7g','xnMmWvKrTMrw0zt4DKpchnRJSNZXp6snPeqYkl','cPYJnBKMqKd0UDLsVC9F','EVXmTTkVonEpzFDPI6ZXNP4BCTSJKtAo','SZDSiZoh3LoPHrM7WtJyZTLZVRMZW64GpT','XMNjwQxVKAr6kDAuMZ4D81LGRXhGBGxjwc57','GTTgO20Obb7JG4XuLWZ7qDiwUN4yFXVO','RwygfhNP67doB9Am0oXq1l2flIPNZCRW','rwLYKxeCf5UXZPJoUTW3','RwqLVUY1HqlSXPBLXiFOyEfalmN','Yri2nJQMIFCGvXnXr0NMZjDdFai1FHhdOFaWZkr40Bq7s','ws5l8pQNMtkXrrmQeLfm6PmV2SCCJCuY1G9VCaO6SPF7qNtMxm','oODZlS9ksfY94BSZh6ETK0oFsCzS3bVjuqNVrXY','FZfI6WP9h','HZKX','9jMnbodgFktKZMGUxhlKBDQOAwadNO3mduJvtd9LjcmuJA','0Qgaxh3VsJiFsB1h6gYxE0ok9imjkepKMswSmfnqpax','BnFCj6xLwytMoBerHEx0vhG1StJIHxwiTE','QzTMdOjYA7wlEwssIHa9bAD0w','D4U5VsUzWPqE9','7P4ZmDrvx0zkpzCJUcG7Cf','YqJD0mEq5IZ3GUZmh3umbQx2ebS3YG2cOSfPPM4VKMhAhk80FC','5YGk6YHQEFmxuUgp3oqJ','NpInwAWShEyAhBHXpo4Zgk','ox94285J','5N6d8LXXrHewaAJPnhP17B2bqg53IQRa','EYkKzFkg0YmtBBPoalOsHv8VnwOGKrRwKhO6gK6','iEVikorkaAd8CNV6bcoi6RvV2gfbyTZ','d75rmJxuNiz8JvuLzRbZmFcT','1y4XU','UKZAGXOcI1','pG','h6c9x4E8','ZmQh8nQksi6FyBSkNA8JZbzIxUCACjEmnL1wrxWV7mY2Od08PU','oxi6s6ZCjRJcCYctfBmtz0qPaKk','9bG1yXp5iDT7amwpy4Adr8Sq0l40pbSzRXDLHJy1dkVWozXZB','zu86S1DRJFK0AA2qlhDoxhFPMSqqLUb0el5xdb0D7w1','0eUem81x7Td4lf6MHES0yIBo','vGCu1eohsmF6NQAY43b712Nl0VxjJrlygv','o6t','l4T8Fo','K21xeYhwYxJz75OLm98bIkbkQGV63dXq0y5lhs1DJeKnlE','3Pw5MY','ehxnZfOa0pQYpKMulr8aIcQMNBIZsKiCxg3TBKk','5v3nBFoy4zOKKs5IHcQVUHNi2TqCHapW','zuql22wTkJL0j40paHkicBtbSvoRfjPq76f5ZyG','gitN69WW1WxxKayv3RIcObi27','3sY6j62VLtOylECIEDCtoDHK3unoDKMeKd7u','CqhzXl2GDq5Q1Cx7LhucG4qvOq2tvg6vTSIWcAgpF3u6zOS','c7MVHA8K1LSAkDof5nCyrLQ92VISF54Mg6Phg0UXRHWENRL'),('AL','CD','OEcKXZ3d5CHSsd3LMCK2EgiB0g','U1X4','eLd8Xbt','KiAUFrovNLL74SZaabOvHds0LInlMCBkU5qaRQqC','bI82B','kN3D','HINxCWG7THv3XkhMWmU','fDjiTt8XE8zV9QEM6Yh3D5uy2YeQn6Hhs3M4uI','IzZzbdQXaHjZC0TNocwuM2bdbi4Q7WnOgHOmLQPZjA','S9wXyI5Ub6kJYCvCuoMFOuIc6k66ODiHt9StdfFZ3X2EB','3RsTzQkB0cjYGGWNNSFWWbqomLx6AGt6n7hlA4pIfiNuGImMi5','uGsgxl46Q6sesua7Ig0tCk7ranZzKpxFUZNueIXMUBPW25R','z','KW9H1GO84VnmruQbcki4Z1z0bBOceu','Z1ilZYKZqn6RNj8Pl1znwOhUK8Ni36eCF1YmVGILTn7cGdc','jtuxOIPwQWWDImJ6sqHBSnFTpWZEWXKxEyKGG','r7ixNseCq6O20TvbNLjWq7F7mYP70lO3uRVPU','mlkgjGXQSrN6uM','rb7oqXoW7SOdYAvIDKI','NqDYMeNXc85wPY46','kcduJsROkyHycwrmUg3SkoNVg7NUbRMIjKsss29H9B','B9YMCJW3i1pg9bhLPdVqGy9GTJL','TyrEzS2FO73H','WOU8zeFC9hleDPI1Js6Bff3DUXdvEqRp7yebkIqT6pvJAjU','pF','ABKnrUXjnHupNS06bvqn0wjL5Kw2urarGoLstUNJbiWG','Mb5Ws0c9tOmbMxdxL0ac3xUZGJKbp2KmE45a8jC5H5','moGyeEdT8upDcJqFxoBHrJ1XVj3dkt','YNX8WMWTXVdAoo','nzBRjDKtfOiZoD','MrZ1RFWPmFZR3LJ7OWYKnhGFzGPbgp','oLaB0','iYzBPfHb0GdvEmoEX3Qg7vH55ayIQAOCIyjVeXG2Nya','f1DAFYNidAAAHhLg98Vg6kGd9sj1rnjKeHU4ncXCDjnVcU7F2j','JoVZCwjEkyB5GaLnMOHJRr2WYLLJkyEMFYmnuVSK9LlYG','AEE876wmuEiat4pmqe','Ni9Aao4BBIASsDo9yra9bFrhBuCIIbnO','4J5WKoH39tKcK','bCC4sJ56w5PF5ddyh03coVtvgCx6hmsZ6pgSDzrKwBY1L5rz','LGOzsTQIhYjdMUWOHIABQlCCqaairRpI1gv','EjAYF4fGDcei4i4dzc7hLDo1apxSsOsQ0K7gB5','v680Y93r','QBtco7LH9PsxmEl5qW9ewThgdmaARRKi6nwgzHi3NuyrPYB','Y5xbX2PCnJ0PS8wcL4g1j4Wa','6rCgwTUWK6m9af4Gu','RUniJ5AsYuV3WlqrGFGvdwl8X3EdbUswqrNRSGdJRJ','jTHz7N8nu1AzktjdGlgFMCSLfxvk1jBLve2l5ncfj86wjAvhak','gy3McZB7WlYbH3KVyrNiyV2dKJQk','N88mLmEzrcm8lZXSmy9nGued0pkrU8Yp','zRsnNVztz3IhqD47WoQkZGOCAh','8hF6JyEMumeWpTpsrcBMvg85H6KWT','hFmfsHYVJ0bFDvhUiFQzxjFj3PiPuSg2sdqh3CpzYuTFlP','QY9G51qjMM9sEbVU6Svkjd1Tsz7GrS1','p8I58Bp1qVqhZQUCPQm3ViwtYzlQZderMq2xJLm8kcuxwQSSF','5ReN22VlgR','P7GPVhOne5K2kQj1U35OUFOin2','91','fzCEOhlAtw3rQ7rEAfW1uhaCGVfv','CgmbTUg6G','2nCGLYzeE5VuTbMiB9MGS2CmoFzYChHvVxQlaWkysPSlt','A3bfOy7171Esc6eFuetha0BbVdUPl3yzsR');
三国小将 2017-11-29
  • 打赏
  • 举报
回复
引用 1 楼 des_xue 的回复:
虽然没试过,但是oledb 对于这种简单的SQL应该是支持,是有什么错误提示吗
System.Data.OleDb.OleDbException:“SQL 语句的结束位置缺少分号 (;)。”
des_xue 2017-11-29
  • 打赏
  • 举报
回复
虽然没试过,但是oledb 对于这种简单的SQL应该是支持,是有什么错误提示吗

110,532

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 C#
社区管理员
  • C#
  • Web++
  • by_封爱
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧