ÌýACMAIN_CHM½¨Ò飬֨пªÌùÁбí½á¹¹ÇóÖú£¬AccessÎÊÌâ
Á½¸ö±í
DayReport±í£¬ÈÕ±¨±í
±í½á¹¹ÈçÏ£º
EquipNo(Êý×Ö) ReportDay£¨ÈÕÆÚ£© Temp01Max£¨Êý×Ö£©Temp01MaxTime£¨ÈÕÆÚ£© Temp01Min£¨Êý×Ö£©Temp01MinTime ....32·
-------------------------------------------------------------------------------------------------------------
1 2010Äê2ÔÂ2ÈÕ 25.2 2010-2-2 19£º00£º00 17.5 2010-2-2 06£º00£º00
DataReceived±í£¬Êý¾Ý½ÓÊÕ±í
±í½á¹¹ÈçÏ£º
EquipNo£¨Êý×Ö£© Rdatadate(ÈÕÆÚ) Rtmp01£¨Êý×Ö£© Rtmp02£¨Êý×Ö£© Rtmp03.¡£¡£¡£Rtmp32
--------------------------------------------------------------------------------------------
1 2010-2-2 19:23:00 18.3 17.6 16.6
(ÒÔÉÏÊý¾ÝΪTestÊý¾Ý)
½ÓÏÂÀ´ÎÒ˵һÏÂʵÏÖÄ¿µÄ£¬DayReportÊÇÈÕ±¨±í£¬DataReceivedÊǽÓÊÕÊý¾ÝµÄ×Ü±í£¬
DataReceivedÊý¾Ý±íÒª½ÓÊÜÿÌìµÄÿ·ÖÖÓÀ´×Ô¸÷·´«¸ÐÆ÷µÄʵʱÊýÖµÐÅÏ¢¼°Ê±¼ä£¬´æ´¢ÆðÀ´£¬DayReportÿÌ콫ǰһÌìij¸öÉ豸£¨¶ÔÓ¦Equipno=1£©¸÷·´«¸ÐÆ÷µÄ×îÖµÐÅÏ¢£¨¶ÔÓ¦Temp01Min£©¼°¶ÔÓ¦³öÏÖµÄʱ¼ä£¨¶ÔÓ¦DataReceived±íµÄRdatadate£©´æ´¢ÆðÀ´£¬ÒòΪһ¹²Éæ¼°32·Êý¾Ý£¨Temp01···Temp32£©£¬ÎÒÿ´ÎÖ»ÄÜÔÚDataReceived
½ÓÊÜ×ܱíÖÐÕÒ³öһ·µÄ×î
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×° ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......
ÎҵijÌÐòÈçÏ£º
Dim Cnn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim myData As String, myTable As String
Dim myFields As Variant, myValue As Var ......