<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!-- #include file="conn.asp" -->
<%
'Á¬½ÓexcelÊý¾Ý¿â
Dim xlsconn,xlsstr,xlsrs,sql,i
Set xlsconn = server.CreateObject("adodb.connection")
xlsstr=& ......
ʱ¼ä¸ñʽ£¿
±ðÄÃcoldatatime ºÍCTimeʲôµÄ˵Ê¡£¡£ËµµãÓÐÓõġ£¡£¡£ËùÓлý·ÖÏàËÍ
ʲôÎÊÌ⣿
format(#2009-1-1#,'yyyy-mm-dd')£¿
select #2009-1-1#
insert into table (mydate) values (#2009-09-21#);
Óû§×Ô¶¨ÒåÈÕÆÚ/ʱ¼ä¸ñʽ (Format º¯Êý)
ÏÂÃæ±í¸ñ±êʶ ......
°¦£¬ÓÉÓÚ²»É÷£¬²Ù×÷´ò°üÈí¼þµÄʱ¼ä°ÑÎÒ×öµÄϵͳŪ¶ªÁË£¬ÕæÊÇÎÞÄΣ¬ÏÖÔÚÓгöÏÖеÄÎÊÌâÁË£¬ÒÔÇ°»¹ºÃºÃµÄ£¬ÕâÊÇÎÒ½«ECXELµ¼ÈëACCESSµÄ´úÂë¡£
Private Sub Command1_Click()
ExportExcelSheetToAccess "Sheet1", "D:\¹Ü¼Ó³µ¼äÐÅϢϵͳ\guanjiaxitong.xls", "xinxi", "D:\¹Ü¼Ó³µ¼ ......
access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»
ÒýÓÃ
access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»
Èç¹ûÖ»Êǵ¼Êý¾Ý,ʹÓÃDTS»òSSISµ¼Èë¼´¿É,ûʲôÏêϸ¹ý³Ì,°´ÕÕ½çÃæÒ»²½Ò»²½×ß¼´¿É.
DTS ²»ÊÇÖ»Ö§³Ö Îı¾¸ñʽÂð£¿
ÁíÍâÄã˵µÃÎÒ¶¼²»ÖªµÀÔÚÄÄÀïÆô¶¯£¬ËùÒÔÇë¸ø³öÏêϸ¹ý³Ì£¬ÎҼǵÃÒÔÇ°ÓиöÍⲿ¹¤¾ßÄ ......
Ë×ö¹ýÕâ·½ÃæµÄ,°ÝÇó..ÌáÐÑÒ»ÏÂ,ÎÒËùÓеķֶ¼ËÍÄã~~~~
Ö±½ÓºÍµ÷ÓñíÏàͬ¡£
select * from table1
select * from qeury1
ÒýÓÃÌáÐÑÒ»ÏÂ,ÎÒËùÓеķֶ¼ËÍÄã~~~~
( ¿ÉÐŶȲ»¸ß°¡)
Liang4 (ÁºËÄ)
'½ØÖÁ2009-09-15 14:13:35 Óû§½áÌûÂÊ12.50% ×Ü·¢Ìû£º8 Õý³£½áÌû£º0 ......
AccessÖеİ´´°ÌåɸѡÊÇʲôÒâ˼£¿
Me.´æÊé²éѯ×Ó´°Ìå.Form.Filter = strWhere
Me.´æÊé²éѯ×Ó´°Ìå.Form.FilterOn = True
ʵ¼ÊÉϾÍÊÇ°´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ
ʵ¼ÊÉϾÍÊÇ°´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ
°´´°Ìå¿Ø¼þÉϵÄÄÚÈÝ×÷Ìõ¼þ¶ÔÊý¾Ý½øÐÐɸѡ
ÉÏÏÂÎÄÊÇʲô£¿
¡°°´´°Ìåɸѡ¡® Õâ¸öÊõ ......