![]() ![]() ![]() ![]() |
|||||
|
|||||
¼Ó¥D ¤pʹ¤l ![]()
![]() |
°²¦p¬Y¼ÐÃDÄæ¦ì[Ápµ¸¤H©m¦W]¦³³]©w´«¦æ,Ápµ¸¤H¤Î©m¦W¤ÀÄÝ¨â¦æ,¤U±µ{¦¡À³«ç»ò§ï? ÁÂÁ |
§O§Ñ®½VP·PÁÂÀ°§U§Aªº¤H | ·s¤â·|ûÁ@¤@Á@ |
1¼Ó |
Ū¶i¨Ó«á ¦AReplace §Y¥i
header1= replace(header,vbcrlf,"") header1= replace(header,vblf,"") header1= replace(header,vbcr,"")
¥»½g¤å³¹¦^ÂЩó2019-03-17 06:28
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
2¼Ó
§@ªÌ¦^À³
¤pʹ¤l ![]() |
¤£¦n·N«ä,§Ú¥i¯à¨Sªí¹F²M·¡.
§Úªº°ÝÃD¬O¸ê®Æ®Ú¥»Åª¤£¶i¨Ó.¼ÐÃDÄæ¦ì[Ápµ¸¤H©m¦W]¦bEXCEL¤¤¬O¤À¦¨¨â¦æ,SELECE¤¤¥Î[Ápµ¸¤H©m¦W]©Î[Ápµ¸¤H]³£Åª¤£¨ì¸ê®Æ, °£«D§â¼ÐÃD§ï¬°¤@¦æ
¥»½g¤å³¹¦^ÂЩó2019-03-17 10:34
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
3¼Ó |
±zµ{¦¡¤Î¸ê®Æ¥i¥H¥á¤W¨Ó¬Ý¤@¤U¶Ü?
µM«á§Ú¦b²q¤£¬O¨S¦³Åª¶i¨Ó¡A¬O§A¨S¦³¬Ý¨ì¦Ó¤w
¥»½g¤å³¹¦^ÂЩó2019-03-17 15:52
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
4¼Ó
§@ªÌ¦^À³
¤pʹ¤l ![]() |
µ{¦¡¦³ÂI¶Ã,¤j·§¦p¤U,¦ýÀɮ׫ç»ò¤W¶Ç?
¥»½g¤å³¹¦^ÂЩó2019-03-17 22:59
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
5¼Ó
§@ªÌ¦^À³
¤pʹ¤l ![]() |
¦bMsgBox(myDS.Tables("AAA_R").Rows.Count) ·|¥X²{NullReferenceException°T®§
¥»½g¤å³¹¦^ÂЩó2019-03-17 23:06
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
6¼Ó |
Catch ex As Exception
¡i³oùجOªÅªº¡j<<----¤£¥¿±` msgbox (ex.message) <----½Ð¥ý§ï¦¨³o¼Ë ¸Õ¤@¤U End TRY °£«D§â¼ÐÃD§ï¬°¤@¦æ <--- ³o¼Ë´NŪ±o¨ì ??? ------------------------------------ ¦pªG¨S¦³¿ù»~°T®§ªº¸Ü Àɮפ£¥Î¤F §Ú¦Û¤w²£¥Í§Y¥i
¥»½g¤å³¹¦^ÂЩó2019-03-17 23:26
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
7¼Ó
§@ªÌ¦^À³
¤pʹ¤l ![]() |
½T©w§â¼ÐÃD§ï¬°¤@¦æ³o¼Ë´NŪ±o¨ì.
ÁÂÁÂ
¥»½g¤å³¹¦^ÂЩó2019-03-17 23:35
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
8¼Ó
³Ì¦³»ùȸѵª
P³¯ ![]() |
±zªºµ{¦¡ ¸g§Ú´ú¸Õµ²ªG ¬O¥i¥H°õ¦æªº ¤]¥i¥HŪ¸ê®Æ¶i¨Ó
1.µ{¦³¤@Ó¦a¤è¤p¿ù (Like «e¨S¦³ªÅ¤@®æ) str1 = "SELECT * FROM [sheet1$A3:K65535] where Ápµ¸¤H©m¦W¤Î¹q¸Ülike '%(07)%'" 2.·íÄæ¦W¬° ABC ©Î DEF ®É¡AŪ¤JTABLE «á´N¬O ABC DEF¡A¦ý ¡iABC´«¦æDEF¡j¡AÄæ¦W·|¦Û°Ê¥[¡i__¡jÅܦ¨ ABC_DEF
¥»½g¤å³¹¦^ÂЩó2019-03-18 07:33
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
9¼Ó |
¦³µo¯¸¤º«Hµ¹±z¤F¡A½Ð¦¬
¥»½g¤å³¹¦^ÂЩó2019-03-18 07:39
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
10¼Ó
§@ªÌ¦^À³
¤pʹ¤l ![]() |
·PÁÂP³¯¤j¤j,¦bÄæ¦W¤¤¥[¡i__¡j´N¥i¥H¤F,ÁÂÁÂ
¥»½g¤å³¹¦^ÂЩó2019-03-18 23:12
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
11¼Ó |
¤w§@¥X¨Ó´N¦n¤F
¥»½g¤å³¹¦^ÂЩó2019-03-19 20:22
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
¦^ÂÐ |
¦pn¦^À³,½Ð¥ýµn¤J. |