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

dotnet讲EXCEL导入ORACLE的代码

From: <由 Windows Internet Explorer 7 保存>
Subject: =?gb2312?B?YyPW0Ljf0Ke1xGV4Y2VstbzI629yYWNsZbXEt723qA==?=
Date: Wed, 4 Mar 2009 20:49:00 +0800
MIME-Version: 1.0
Content-Type: multipart/related;
	type="multipart/alternative";
	boundary="----=_NextPart_000_00BB_01C99D0A.A505BBE0"
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350

This is a multi-part message in MIME format.

------=_NextPart_000_00BB_01C99D0A.A505BBE0
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-Location: http://www.tzwhx.com/images/GIF/arrow.gif

77u/PCFET0NUWVBFIGh0bWwgUFVCTElDICItLy9XM0MvL0RURCBYSFRNTCAxLjAgVHJhbnNpdGlv
bmFsLy9FTiIgImh0dHA6Ly93d3cudzMub3JnL1RSL3hodG1sMS9EVEQveGh0bWwxLXRyYW5zaXRp
b25hbC5kdGQiPg0KDQo8aHRtbCB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMTk5OS94aHRtbCI+
DQo8aGVhZD4NCiAgICA8dGl0bGU+5YWz5LqO54us5LiK6auY5qW8572R56uZ6LW355So5paw5Z+f
5ZCN55qE6YCa55+lPC90aXRsZT4NCiAgICA8bGluayByZWw9IlN0eWxlc2hlZXQiIGhyZWY9Ii9B
cHBfdGhlbWVzL015dGhlbWUvTXl0aGVtZS5jc3MiIHR5cGU9InRleHQvY3NzIiAvPg0KPC9oZWFk
Pg0KPGJvZHk+DQo8Zm9ybSBpZD0iZm9ybTEiPg0KICAgICA8bGFiZWwgZm9yPSJwYWdlYm9keTEi
IHN0eWxlPSJkaXNwbGF5OiBub25lIj48L2xhYmVsPg0KICAgIDxmaWVsZHNldCBpZD0iY29udGFp
bmVyIj4NCiAgICAgICAgPGxlZ2VuZD7nvZHnq5notbfnlKjmlrDln5/lkI08L2xlZ2VuZD4NCiAg
ICAgICAgPGRpdiBjbGFzcz0iZnJpZW5kc2hpcCI+DQogICAgICAgICAgICA8dWwgc3R5bGU9Indp
ZHRoOiAxMDA4cHg7IG1hcmdpbjogMHB4Ij4NCiAgICAgICAgICAgIDxsaT4NCiAgICAgICAgICAg
ICAgICA8aW1nICBhbHQ9IuWFs+S6juacrOe9keermei1t+eUqOaWsOWfn+WQjeeahOmAmuefpSIg
c3JjPSIvSW1hZ2VVcGxvYWQvMjAwODA5MzAvaW1hZ2VzLzIwMDg3MjYyMzM1MzkzOS5qcGciIHdp
ZHRoPSIyMDAiIGhlaWdodD0iMzAwIi8+DQogICAgICAgICAgICA8L2xpPg0KICAgICAgICAgICAg
PGxpIHN0eWxlPSJ3aWR0aDogODA4cHg7Zm9udC1zaXplOiAzMnB4OyBsaW5lLWhlaWdodDogNDhw
eDsgY29sb3I6ICNmZmZmZmY7Ij4NCiAgICAgICAgICAgICAgICAmbmJzcDvlkITkvY3mnIvlj4vv
vIwg5L2g5Lus5aW977yBPGJyIC8+DQogICAgICAgICAgICAgICAgICAgICAgICAg44CA44CA55Sx
5LqO5pys572R56uZ6LW355So5LqG5paw5Z+f5ZCN77yM5oKo5omA6KaB5p+l55yL55qE572R6aG1
77yM6ZyA6KaB5Zyo5pys572R56uZ5Lit6YeN5paw5p+l5om+77yM55Sx5q2k6ICM57uZ5oKo5bim
5p2l55qE6bq754Om77yM5oiR5Lus5rex6KGo5qyg5oSP44CCDQogICAgICAgICAgICAgICAg5oiR
5Lus572R56uZ55qE5paw5Z+f5ZCN5piv77yaPGEgY2xhc3M9ImhlYWRlcjEiIGhyZWY9Ii9UWkdU
V0hYLmFzcHgiIHRhcmdldD0iX2JsYW5rIiBzdHlsZT0iZm9udC1zaXplOiAzMnB4Ij5odHRwOi8v
d3d3LnR6d2h4LmNvbTwvYT7vvIzjgIDosKLosKLkvaDlr7nmnKznvZHnq5nnmoTlhbPniLHjgIIN
CiAgICAgICAgICAgIDwvbGk+DQogICAgICAgIDwvdWw+DQogICAgICAgIDwvZGl2Pg0KICAgIDwv
ZmllbGRzZXQ+DQogICAgPC9mb3JtPg0KPC9ib2R5Pg0KPC9odG1sPg0K

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

BODY {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 12px; PADDING-BOTTOM: =
0px; MARGIN: 0px; COLOR: #4f4f4f; LINE-HEIGHT: 14pt; PADDING-TOP: 0px; =
BACKGROUND-REPEAT: repeat; FONT-FAMILY: =
Arial,Helvetica,=CB=CE=CC=E5,sans-serif,Times,serif,Courier,monospace; =
BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left
}
FIELDSET#container {
	BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: =
0px; MARGIN: 10px auto; WIDTH: 1008px; POSITION: relative; =
BORDER-RIGHT-WIDTH: 0px
}
FIELDSET {
	BORDER-RIGHT: 0px; PADDING-RIGHT: 1px; BORDER-TOP: 0px; MARGIN: 0px =
auto; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px
}
FIELDSET.class_A {
	BORDER-RIGHT: 0px; BORDER-TOP: 0px; MARGIN: 4px 0px 0px; BORDER-LEFT: =
0px; BORDER-BOTTOM: 0px
}
UL.class_A {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: =
0px; PADDING-TOP: 0px
}
LI.user {
	FONT-WEIGHT: bold; FONT-SIZE: 14px; WIDTH: 100%; COLOR: #ffffff; =
LINE-HEIGHT: 32px; HEIGHT: 32px; BACKGROUND-COLOR: #9d8d7d
}
LI.class_A {
	PADDING-RIGHT: 0px; WIDTH: 33%; MARGIN-RIGHT: 0px
}
LI {
	FLOAT: left
}
LEGEND {
	DISPLAY: none
}
DIV {
	BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; =
BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; =
MARGIN: 0px; OVERFLOW: hidden; PADDING-TOP: 0px; BORDER-RIGHT-WIDTH: 0px
}
UL {
	BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; =
BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; =
MARGIN: 0px; OVERFLOW: hidden; PADDING-TOP: 0px; BORDER-RIGHT-WIDTH: 0px
}
LI {
	BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; =
BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; =
MARGIN: 0px; OVERFLOW: hidden; PADDING-TOP: 0px; BORDER-RIGHT-WIDTH: 0px
}
DIV.window {
	BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: =
0px; MARGIN: 0px; WIDTH: 1008px; BORDER-RIGHT-WIDTH: 0px
}
DIV#head {
	BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; =
BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; =
MARGIN: 0px; WIDTH: 1008px; PADDING-TOP: 0px; POSITION: relative; =
HEIGHT: 162px; BORDER-RIGHT-WIDTH: 0px
}
DIV#content {
	BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; =
BORDER-LEFT-WIDTH: 0px; LEFT: 0px; BORDER-BOTTOM-WIDTH: 0px; =
PADDING-BOTTOM: 0px; MARGIN: 0px; WIDTH: 1008px; PADDING-TOP: 0px; =
POSITION: relative; TOP: 160px; BACKGROUND-COLOR: #ffff66; =
BORDER-RIGHT-WIDTH: 0px
}
DIV.foot {
	BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; LEFT: 0px; =
BORDER-BOTTOM-WIDTH: 0px; MARGIN: 0px; WIDTH: 1008px; POSITION: =
relative; BACKGROUND-COLOR: #ffffff; BORDER-RIGHT-WIDTH: 0px
}
DIV.friendship {
	BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; LEFT: 0px; =
BORDER-BOTTOM-WIDTH: 0px; MARGIN: 0px auto; WIDTH: 1008px; =
BACKGROUND-COLOR: #c0c0c0; BORDER-RIGHT-WIDTH: 0px
}
DIV#pagebody1 {
	MARGIN: 0px auto; WIDTH: 808px; HEIGHT: 100%
}
DIV#pagebodyClassA {
	MARGIN: 0px auto; WIDTH: 1008px; HEIGHT: 100%
}
DIV.sidebar {
	BORDER-TOP-WIDTH: 0px; CLEAR: left; PADDING-RIGHT: 1px; PADDING-LEFT: =
1px; BORDER-LEFT-WIDTH: 0px; FLOAT: left; BORDER-BOTTOM-WIDTH: 0px; =
PADDING-BOTTOM: 1px; WORD-SPACING: 1px; OVERFLOW: hidden; WIDTH: 460px; =
PADDING-TOP: 1px; HEIGHT: 100%; TEXT-ALIGN: left; BORDER-RIGHT-WIDTH: =
0px
}
DIV.mainbody {
	BORDER-TOP-WIDTH: 0px; CLEAR: right; PADDING-RIGHT: 1px; PADDING-LEFT: =
1px; BORDER-LEFT-WIDTH: 0px; FLOAT: right; BORDER-BOTTOM-WIDTH: 0px; =
PADDING-BOTTOM: 1px; WORD-SPACING: 1px; OVERFLOW: hidden; WIDTH: 348px; =
PADDING-TOP: 1px; HEIGHT: 100%; TEXT-ALIGN: left; BORDER-RIGHT-WIDTH: =
0px
}
DIV.sidebar1 {
	BORDER-TOP-WIDTH: 0px; CLEAR: left; PADDING-RIGHT: 1px; PADDING-LEFT: =
1px; BORDER-LEFT-WIDTH: 0px; FLOAT: left; BORDER-BOTTOM-WIDTH: 0px; =
PADDING-BOTTOM: 1px; WORD-SPACING: 1px; OVERFLOW: hidden; WIDTH: 266px; =
PADDING-TOP: 1px; HEIGHT: 100%; TEXT-ALIGN: left; BORDER-RIGHT-WIDTH: =
0px
}
DIV.sidebar2 {
	BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 1px; PADDING-LEFT: 1px; =
BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 1px; =
WORD-SPACING: 1px; MARGIN-LEFT: 276px; OVERFLOW: auto; WIDTH: 266px; =
PADDING-TOP: 1px; HEIGHT: 100%; TEXT-ALIGN: left; BORDER-RIGHT-WIDTH: =
0px
}
DIV.sidebar3 {
	BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 1px; PADDING-LEFT: 1px; =
BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 1px; =
WORD-SPACING: 1px; MARGIN-LEFT: 540px; OVERFLOW: auto; WIDTH: 266px; =
PADDING-TOP: 1px; HEIGHT: 100%; TEXT-ALIGN: left; BORDER-RIGHT-WIDTH: =
0px
}
DIV.marquee {
	BORDER-TOP-WIDTH: 0px; CLEAR: left; PADDING-RIGHT: 1px; PADDING-LEFT: =
1px; BORDER-LEFT-WIDTH: 0px; FLOAT: left; BORDER-BOTTOM-WIDTH: 0px; =
PADDING-BOTTOM: 1px; WORD-SPACING: 1px; OVERFLOW: hidden; WIDTH: 460px; =
PADDING-TOP: 1px; HEIGHT: 24px; TEXT-ALIGN: left; BORDER-RIGHT-WIDTH: =
0px
}
DIV.banner {
	CLEAR: both; BACKGROUND: url(banner.jpg) no-repeat 0px 30px; MARGIN: =
0px auto; OVERFLOW: hidden; WIDTH: 1008px; BORDER-BOTTOM: #6699cc 1px =
solid; HEIGHT: 1px
}
DIV.header_A {
	BORDER-TOP-WIDTH: 0px; CLEAR: left; BORDER-LEFT-WIDTH: 0px; FLOAT: =
left; BORDER-BOTTOM-WIDTH: 0px; OVERFLOW: hidden; WIDTH: 1008px; HEIGHT: =
36px; BACKGROUND-COLOR: #827064; TEXT-ALIGN: center; BORDER-RIGHT-WIDTH: =
0px
}
DIV.header_B {
	BORDER-TOP-WIDTH: 0px; CLEAR: left; BORDER-LEFT-WIDTH: 0px; FLOAT: =
left; BORDER-BOTTOM-WIDTH: 0px; OVERFLOW: hidden; WIDTH: 1008px; HEIGHT: =
24px; BACKGROUND-COLOR: #afa899; TEXT-ALIGN: center; BORDER-RIGHT-WIDTH: =
0px
}
DIV.header_C {
	BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; =
BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; =
MARGIN: 0px; WIDTH: 1008px; PADDING-TOP: 0px; HEIGHT: 32px; =
BACKGROUND-COLOR: #c8bda9; BORDER-RIGHT-WIDTH: 0px
}
LI.menuDiv_A {
	BACKGROUND: #ffffff; MARGIN-LEFT: 3px; WIDTH: 1px; MARGIN-RIGHT: 3px; =
HEIGHT: 15px
}
LI.menuDiv_B {
	BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BACKGROUND: #ffffff; =
BORDER-BOTTOM-WIDTH: 0px; MARGIN-LEFT: 3px; WIDTH: 1px; MARGIN-RIGHT: =
3px; HEIGHT: 12px; BORDER-RIGHT-WIDTH: 0px
}
DIV.menu {
	FLOAT: right; MARGIN: 0px; WIDTH: 1008px; LIST-STYLE-TYPE: none
}
UL.tr3 {
	BORDER-TOP-WIDTH: 0px; CLEAR: left; BORDER-LEFT-WIDTH: 0px; FLOAT: =
left; BORDER-BOTTOM-WIDTH: 0px; OVERFLOW: hidden; WIDTH: 1008px; HEIGHT: =
36px; BACKGROUND-COLOR: #827064; TEXT-ALIGN: center; BORDER-RIGHT-WIDTH: =
0px
}
UL.ul_A {
	PADDING-RIGHT: 4px; MARGIN-TOP: 10px; PADDING-LEFT: 4px; =
PADDING-BOTTOM: 4px; MARGIN-LEFT: 70px; PADDING-TOP: 4px; =
LIST-STYLE-TYPE: none; TEXT-ALIGN: center
}
UL.ul_B {
	PADDING-RIGHT: 4px; PADDING-LEFT: 4px; PADDING-BOTTOM: 4px; =
MARGIN-LEFT: 30px; PADDING-TOP: 4px; LIST-STYLE-TYPE: none
}
UL.ul_C {
	MARGIN-TOP: 0px; MARGIN-LEFT: 80px; LIST-STYLE-TYPE: none; TEXT-ALIGN: =
center
}
UL.ul_D {
	PADDING-RIGHT: 0px; MARGIN-TOP: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: =
0px; MARGIN-LEFT: 270px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; =
TEXT-ALIGN: center
}
TABLE {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: =
0px; WORD-SPACING: 1px; PADDING-TOP: 0px
}
TABLE.tableclass0 {
	PADDING-RIGHT: 1px; PADDING-LEFT: 1px; PADDING-BOTTOM: 1px; MARGIN: =
0px; WORD-SPACING: 1px; PADDING-TOP: 1px
}
TR.class0 {
	BACKGROUND-COLOR: #f4f4e9
}
TR.class1 {
	BACKGROUND-COLOR: #f4f4e9
}
TD.tdclass0 {
=09
}
H1 {
	FONT-WEIGHT: bold; FONT-SIZE: 24px; LINE-HEIGHT: 24pt
}
H2 {
	FONT-WEIGHT: bold; FONT-SIZE: 18px; LINE-HEIGHT: 18pt
}
H3 {
	FONT-WEIGHT: bold; FONT-SIZE: 14px; LINE-HEIGHT: 14pt
}
H4 {
	FONT-WEIGHT: bold; FONT-SIZE: 12px
}
H5 {
	FONT-WEIGHT: bold; FONT-SIZE: 12px
}
H6 {
	FONT-WEIGHT: bold; FONT-SIZE: 12px
}
P {
	LINE-HEIGHT: 1.2em
}
TH {
	COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: #9d8d7d
}
TH.class1 {
	FONT-SIZE: 14px; BACKGROUND-COLOR: #9d8d7d
}
TH.class2 {
	FONT-SIZE: 14px; COLOR: #ffffff; HEIGHT: 32px; BACKGROUND-COLOR: =
#9d8d7d