c#中高效的excel导入oracle的方法.mht

dotnet讲EXCEL导入ORACLE的代码

}
TH.class3 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#9d8d7d
}
TH.class4 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#9d8d7d
}
TH.class5 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#9d8d7d
}
TH.class6 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#9d8d7d
}
TH.class7 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#9d8d7d
}
TH.class8 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#9d8d7d
}
TH.class9 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#9d8d7d
}
TH.class11 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#9d8d7d
}
TH.class12 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#9d8d7d
}
TH.class13 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#cc0099
}
A {
	FONT-SIZE: 12px; COLOR: #4f4f4f
}
A:link {
	TEXT-DECORATION: none
}
A:hover {
	BACKGROUND-COLOR: #ff99ff; TEXT-DECORATION: underline
}
A:visited {
	TEXT-DECORATION: none
}
A:active {
	TEXT-DECORATION: none
}
A.bold {
	FONT-WEIGHT: bold; FONT-SIZE: 14px; COLOR: #ffffff
}
A.nobold {
	FONT-SIZE: 12px; COLOR: #ffffff
}
A.header1 {
	FONT-WEIGHT: bold; FONT-SIZE: 15px; COLOR: #ffffff
}
A.header2 {
	FONT-WEIGHT: bold; FONT-SIZE: 12px; COLOR: #ffffff
}
A.header3 {
	FONT-SIZE: 12px; COLOR: #ffffff
}
A.header4 {
	FONT-SIZE: 12px; COLOR: #ffffff
}
A.subMenu {
	FONT-SIZE: 14px; COLOR: #0099cc; LINE-HEIGHT: 24px
}
A.onetilte {
	FONT-SIZE: 14px; COLOR: #333333; LINE-HEIGHT: 24px
}
A.title {
	COLOR: #4f4f4f
}
A.classname {
	COLOR: #0099cc
}
EM.onehints {
	FONT-SIZE: 12px; COLOR: #cc9966
}
EM.onearticleid {
	COLOR: #4f4f4f
}
EM.datate {
	FONT-SIZE: 12px; COLOR: #4f4fcc
}
LEGEND {
	DISPLAY: none
}
FIELDSET.web_800 {
	MARGIN-TOP: 0px; MARGIN-LEFT: 2px; WIDTH: 808px
}
FIELDSET.web_2 {
	WIDTH: 808px; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none; =
BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none
}
DIV.web2 {
	MARGIN-LEFT: auto; WIDTH: 804px; HEIGHT: 100%
}
DIV.table_tr {
	BORDER-TOP-WIDTH: 0px; CLEAR: left; MARGIN-TOP: 10px; =
BORDER-LEFT-WIDTH: 0px; FLOAT: left; BORDER-BOTTOM-WIDTH: 0px; OVERFLOW: =
hidden; WIDTH: 804px; TEXT-ALIGN: left; BORDER-RIGHT-WIDTH: 0px
}
DIV.web_800 {
	BORDER-TOP-WIDTH: 0px; CLEAR: left; MARGIN-TOP: 2px; BORDER-LEFT-WIDTH: =
0px; FLOAT: left; BORDER-BOTTOM-WIDTH: 0px; MARGIN-LEFT: 2px; OVERFLOW: =
hidden; WIDTH: 808px; HEIGHT: 100%; TEXT-ALIGN: left; =
BORDER-RIGHT-WIDTH: 0px
}
UL.web2 {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; RIGHT: 0px; LEFT: 0px; FLOAT: =
left; PADDING-BOTTOM: 0px; MARGIN: 0px; BOTTOM: 0px; PADDING-TOP: 0px; =
LIST-STYLE-TYPE: none; TOP: 0px
}
UL.web_400 {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: =
0px; WIDTH: 808px; PADDING-TOP: 0px
}
LI.web_400 {
	MARGIN-LEFT: 4px; WIDTH: 398px
}
LI.web2 {
	WIDTH: 200px
}
LI.mapgif {
	BACKGROUND: url(/images/GIF/whx0000.gif) no-repeat; WIDTH: 24px; =
HEIGHT: 24px
}
LI.titileA {
	FONT-WEIGHT: bold; FONT-SIZE: 24px; WIDTH: 804px; COLOR: #ffffff; =
LINE-HEIGHT: 32px; HEIGHT: 48px; BACKGROUND-COLOR: #666666; TEXT-ALIGN: =
center
}
LI.titileB {
	FONT-WEIGHT: bold; FONT-SIZE: 18px; WIDTH: 804px; COLOR: #ffffff; =
LINE-HEIGHT: 24px; HEIGHT: 32px; BACKGROUND-COLOR: #999966; TEXT-ALIGN: =
center
}
LI.titileC {
	FONT-WEIGHT: bold; FONT-SIZE: 14px; WIDTH: 804px; COLOR: #ffffff; =
LINE-HEIGHT: 28px; HEIGHT: 28px; BACKGROUND-COLOR: #9d8d7d; TEXT-ALIGN: =
center
}
.menuDiv {
	BACKGROUND: #999; WIDTH: 1px; HEIGHT: 28px
}
UL {
	MARGIN: 0px; LIST-STYLE-TYPE: none
}
LI {
	MARGIN: 0px; LIST-STYLE-TYPE: none
}
DIV.usersidebar {
	BORDER-TOP-WIDTH: 0px; CLEAR: left; BORDER-LEFT-WIDTH: 0px; FLOAT: =
left; BORDER-BOTTOM-WIDTH: 0px; OVERFLOW: hidden; WIDTH: 135px; =
TEXT-ALIGN: left; BORDER-RIGHT-WIDTH: 0px
}
DIV.usermainbody {
	BORDER-TOP-WIDTH: 0px; CLEAR: right; BORDER-LEFT-WIDTH: 0px; FLOAT: =
right; BORDER-BOTTOM-WIDTH: 0px; OVERFLOW: hidden; WIDTH: 190px; =
TEXT-ALIGN: left; BORDER-RIGHT-WIDTH: 0px
}

------=_NextPart_000_00BB_01C99D0A.A505BBE0
Content-Type: text/css;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable
Content-Location: http://www.tzwhx.com/App_Themes/classmain/css.css

BODY {
	BACKGROUND: #fff; MARGIN: 0px; FONT: 12px Tahoma; TEXT-ALIGN: center
}
UL {
	LIST-STYLE-TYPE: none
}
LEGEND {
	DISPLAY: none
}
FIELDSET {
	BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: =
none; BORDER-BOTTOM-STYLE: none
}
#container {
	MARGIN: 10px auto; WIDTH: 1008px
}
DIV#Header {
	BACKGROUND: #827064; MARGIN: 0px auto; WIDTH: 1008px; HEIGHT: 100px
}
DIV.menu {
	FLOAT: right; MARGIN: 0px; WIDTH: 1008px; LIST-STYLE-TYPE: none
}
DIV.menuDiv {
	BACKGROUND: #999; WIDTH: 1px; HEIGHT: 28px
}
DIV#PageBody {
	BACKGROUND: #ccff00; MARGIN: 0px auto; WIDTH: 1008px; HEIGHT: 400px
}
DIV#Footer {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BACKGROUND: #ffffff; =
PADDING-BOTTOM: 0px; MARGIN: 0px auto; WIDTH: 1008px; PADDING-TOP: 0px; =
HEIGHT: 100%
}
DIV.banner {
	CLEAR: both; BACKGROUND: url(banner.jpg) no-repeat 0px 30px; MARGIN: =
0px auto; WIDTH: 1008px; BORDER-BOTTOM: #000000 1px solid; HEIGHT: 1px
}
DIV#pagebody {
	MARGIN: 8px auto; WIDTH: 1008px
}
DIV#sidebar {
	BORDER-TOP-WIDTH: 0px; CLEAR: left; BORDER-LEFT-WIDTH: 0px; FLOAT: =
left; BORDER-BOTTOM-WIDTH: 0px; OVERFLOW: hidden; WIDTH: 200px; =
TEXT-ALIGN: left; BORDER-RIGHT-WIDTH: 0px
}
DIV#mainbody {
	CLEAR: right; BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px =
solid; FLOAT: right; OVERFLOW: hidden; BORDER-LEFT: #cccccc 1px solid; =
WIDTH: 804px; BORDER-BOTTOM: #cccccc 1px solid; TEXT-ALIGN: left
}

------=_NextPart_000_00BB_01C99D0A.A505BBE0
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-Location: http://eiv.baidu.com/uapimg/duba/800x60.gif

R0lGODlhIAM8APf/AO5zdjUyMv/cutTl8ru7u//69aalpV2Dt8mvr9oMFANttv/jyP/06v/VrLfG
3gaKzoiIiP/s2tQIDa3U7v/y5TSIyP/p1OZlW6wtMP/gwY3O8YsoK+RUSdhOTmAcHq6Rkf/ZtFWx
5cQxNOvr6+ERHPLy8yF2t8Td793d3e0aKuNLQvMeMPoiOP/8+Zqw0kRDQ3d4eNwyMwAAAOFEQfWj
qOI+O6XD3uVcUfnP0QJRmEt1qunz+szMzPAbLd2BfUiW0Ge56MPBwsiSjvfDxP0lPJuZmdMyM2mp
1+2IiX98ff/27mdmZrl+fd0jJVGj2qR1dPS7u5GIiJdDRePj43bF7vn5+fwkO+UUINTT0xkYF7dP
TgJ9xP/UqeF0buA1Nvzg4lVVVcnExMkAAOgWJPghNu84Rv/v39XIx/YfM//48WyQv+ne298PGdPb
4LCrq3FnZ/X5/MzS1NYJD15WVlBFRO6amQRdpv/9/N0OFvH2+Z+kp/J+hTyr4tQHDN7t9/awjbKy
tMgnKuE6N/3w8P78/Pz8/OQkKv/798DO34+coIKdxujn5uKppYaVmNgAA/STmAIwdgiY14m74PXT
yzab2No6Nr3JzOUvK+Pp6t48OKmqq/7RqdG8u+07MvojOb8vMjRmoBEAAGl0eOsmNCVZlcujodHW
2vsjOu9bW9YsLSEREd/m6+sYJ8LFx+KRieXHxulCS+C5uM9dWvr8/fzs7Pj7/eDS0eLX1dfW125t
bf///6wdHhZBgPItKuw1Lvv+/+o0QPv8/u7u7thBOvz7+80gJPb29tI2NtgzM+5ZY4sVFZRdXec3
MstCQGRfXu1COeUyN97g4fPIvwNDh9HQ0PaxtIKNj5COj56dndgKEcnGx8nJyuc8NvAqOYBZWv/+
/f/XsP7+/v///f7+//rd3aKgoP/mzpWTlGNrbv7///j4+NrZ2tkGCSUiIj99uswNDfzIn7RAQFBN
TR6e2v3MohAQEMgbH11MTb+9vu9GU/v7+7RjYnVxcf39/enw9P///yH/C05FVFNDQVBFMi4wAwEA
AAAh+QQFFAD/ACwAAAAAIAM8AAAI/wCJCLQykKDAgwitGDxocCERhwkRRnzYUCJDiwUVStQ48eLD
hBAXimQokuPAjRAjmiSJ0iJHggpDniRZMWPHlzEbpjypsebMgj8xrmyJ0eXOoR5nwgTKsqjOoh0p
MoVKk+jHphN1xqSI1GpUrhtdejUalurLm1J9XpVqU6hTtlTXstW6MyhRk0PVpo1rtmtdvEK3+n3K
daRdqDhBToVrluxGXZAjRzaGa90tVzdqzFDBmTOHz59viB5NeoaX06hTq17tJYbrGMhix06VKgYq
KUn0aFriTF4AA5KDCx9OvLjx48iTK1/OvLnz59CjS59Ovbr169iv49wKNiPMnIIdgv8P7BM8Xe85
GY83v7Sw+5WAe6LnPrcnYY/sw68tmR8+//ncfZdeeu6pR9943ZkHIHjFUbbOGnVktllnKoAWGmkY
1sDahqu9BptsyBghom246ZaLM2D8lt2KLLbo4oswxijjjDTWmFxh+RXY34487rhgj+sBSeCAQhZp
5JE94likkksyieSTQJ7SYGUQSkihhRxgqGUNMXDoZWsegiiiESTmpgk/S8yh4nQQtNnmEppApgkE
uqBQjwx45olnPcIE16ZxKCxh3BIwHAcDGDYmquiijDbqqHZFngLeKZJaQalCl+ZEaab5cbppp0ZW
at6nl3I6qagxZVqpqaGiOmmqp7r/euqokspqqaW2RtrppqKuCiuv/bEqK6quSkmcg2swcoFmV1qo
5QWiQStIl1+y5mEMtMU2Jpm35WYAP284s2ZxENRj7rnoFvpCPWC0084L7QgjTDuFQtDOEvjmi68M
BOhCgJvrugkBCpKh0E49LwQnDBgM1xMAwxD3CQHEAbALcZyPZqzxxhx3bF2qvAK7asiw4kqyyaXW
iqnII9eqasqf4gpyyKqifLLLppLa8q0rExuzziOjLLPJQtP8cswrY2ozzUurLPTQOs+sqdLASt2r
pjjXbOmUD1azLIUVgobhBWSXfcO01Xb4WiqVyDJMKttyW+K3J45LnDA88BDAEnn3/82DxPXoAsYL
5TY8MATrCmMvnRAs0Q4Bdr7AcAAPT95OZAS8q/fjkrUJRj0C/8mDDPrq+7nHqKeu+uoan+KJJ5u+
7vrrsNNce+yyG+267bze3vvvuveeO6W+E0+878ULH/zxLC9fO+zPH08788mHfHv1y+uOvezPFz89
7dEbXT322RuP+9GeTInLGlB83eyF0ZZdNgdpq+3aJTE8YYMrtG1bph7l4EfdgIMcYTgMYmAQFGQK
147KHRAM/3IcBGDQDhmgAAwUJMDoeKALAxYKMhTs4BLYFZnPgYFgkdnbcEaHLhmgK2Gsi6EMZ0hD
6rDghjh8HQvA54kb9lCHueOh7P9YELsd/lCHOezhDnFoRB8q8YhMFCLxiAg+Jz6Rhz48BQ61uEQg
VjGLXhxiE6l4xe+VcXZjLKMQg6jEJXbxhlxMohOtaETazdGKPKSeFO34RC5CMY6za6Mb4ZhD6bFA
fWuQhvs646zRyG9+9UvNa5CBv2XowQ9rUAHcxoSMbukBG28Il92KowkZhE4GHNRFuSDwMMiALjKN
K1c7ELeEANgLcvUgmOMkUw8YFMFc7UBgu8xFABig65j1KMLC5DXCXNaJczWMpjSnOU0kCjKHTfyi
D7FpTS8y0Y1X/CY2oxjObpLzhj1IpzrXyc52uvOd8IynPOdJz3ra8574xCcZxCn/xyfKcYxunJIp
1jCJRXpGbI585AXoF8nTuAYZrllGIqIhjDz4oH9j8iQ2nMHRURLHmJLZ4AIDxzBX0mmBSzAgKgmA
Jx48zpjIRBcKeFAEN5myTUXgIN4c57e+QQYFFAwAAUgIL2oa9ahI7Rg/l8rUpuJwn0wkA1SZKtWo
OpUFU+XnCtgghk3G7atgDatYx0rWspr1rGhNq1rX+tV3SGAMWbXqVat6QzII9BYFrQHYGplQ+amA
WvW7lkQpuogdQAEZXjWCJ88BhjmoiYDHkVzn+DRSVsYUBo3TxQghczBdPA5vmuhl30aYt+CIVDgN
DB0EilAnh0Egc+YKQDtQmNTa/9r2tjCSqm7rSlfd7harUPWtcIdLXOAW17jCRe5vfQtcrI5BDD4Y
xDemS93qWve62M2udrfL3e5697vgDa94xzuEVLCht7sNbnGXa9dj4cIUeDVo2OAXP78CNm0eWkYj
CLuIEYzgBoldLB3k4RvIGueVkdnlSNsFBh6EtsF/y2wF+5U4zs0Lhh3sZedsKrDOCfNzgasTUOux
BAi4kLa4TbGKV/wc4rr4xTCOsYxnTOMVvEMa482xjnfM4x77+MfTLUAHSEDjGQvUFgXNxF4ROrYb
kG0G9/1SfhuBghEs4sqFZURib1Cia7zgyx4dzrqOiaiRCu5xJg6xKpdQBBlIjv+lpuScnWbZp6JG