Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : access

EXCEL µ¼Èëµ½ACCESSÊý¾Ý¿âÖÐÉÙÁËһЩÊý¾Ý

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!-- #include file="conn.asp" -->
<%
'Á¬½ÓexcelÊý¾Ý¿â
Dim xlsconn,xlsstr,xlsrs,sql,i
       
Set xlsconn = server.CreateObject("adodb.connection")
xlsstr=& ......

access ÈÕÆÚ select,insert ¸ñʽ

ʱ¼ä¸ñʽ£¿
±ðÄÃcoldatatime ºÍCTimeʲôµÄ˵Ê¡£¡£ËµµãÓÐÓõġ£¡£¡£ËùÓлý·ÖÏàËÍ
ʲôÎÊÌ⣿
format(#2009-1-1#,'yyyy-mm-dd')£¿
select #2009-1-1#


insert into table (mydate) values (#2009-09-21#);

Óû§×Ô¶¨ÒåÈÕÆÚ/ʱ¼ä¸ñʽ (Format º¯Êý)
     

ÏÂÃæ±í¸ñ±êʶ ......

¿ÞÁË£¡¹ØÓÚEXCELµ¼ÈëACCESSµÄÎÊÌ⣡

°¦£¬ÓÉÓÚ²»É÷£¬²Ù×÷´ò°üÈí¼þµÄʱ¼ä°ÑÎÒ×öµÄϵͳŪ¶ªÁË£¬ÕæÊÇÎÞÄΣ¬ÏÖÔÚÓгöÏÖеÄÎÊÌâÁË£¬ÒÔÇ°»¹ºÃºÃµÄ£¬ÕâÊÇÎÒ½«ECXELµ¼ÈëACCESSµÄ´úÂë¡£

Private Sub Command1_Click()
ExportExcelSheetToAccess "Sheet1", "D:\¹Ü¼Ó³µ¼äÐÅϢϵͳ\guanjiaxitong.xls", "xinxi", "D:\¹Ü¼Ó³µ¼ ......

access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì

access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»
ÒýÓÃ
access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»

Èç¹ûÖ»Êǵ¼Êý¾Ý,ʹÓÃDTS»òSSISµ¼Èë¼´¿É,ûʲôÏêϸ¹ý³Ì,°´ÕÕ½çÃæÒ»²½Ò»²½×ß¼´¿É.

DTS ²»ÊÇÖ»Ö§³Ö Îı¾¸ñʽÂð£¿
ÁíÍâÄã˵µÃÎÒ¶¼²»ÖªµÀÔÚÄÄÀïÆô¶¯£¬ËùÒÔÇë¸ø³öÏêϸ¹ý³Ì£¬ÎҼǵÃÒÔÇ°ÓиöÍⲿ¹¤¾ßÄ ......

vc ÔõôµôÓà Access ×Ô¼ºÉè¼ÆºÃµÄ²éѯ

Ë­×ö¹ýÕâ·½ÃæµÄ,°ÝÇó..ÌáÐÑÒ»ÏÂ,ÎÒËùÓеķֶ¼ËÍÄã~~~~
Ö±½ÓºÍµ÷ÓñíÏàͬ¡£

select * from table1

select * from qeury1

ÒýÓÃÌáÐÑÒ»ÏÂ,ÎÒËùÓеķֶ¼ËÍÄã~~~~

( ¿ÉÐŶȲ»¸ß°¡)
Liang4 (ÁºËÄ)
  '½ØÖÁ2009-09-15 14:13:35  Óû§½áÌûÂÊ12.50%  ×Ü·¢Ìû£º8  Õý³£½áÌû£º0 ......

AccessÖеİ´´°ÌåɸѡÊÇʲôÒâ˼£¿

AccessÖеİ´´°ÌåɸѡÊÇʲôÒâ˼£¿
Me.´æÊé²éѯ×Ó´°Ìå.Form.Filter = strWhere
    Me.´æÊé²éѯ×Ó´°Ìå.Form.FilterOn = True
ʵ¼ÊÉϾÍÊÇ°´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ

ʵ¼ÊÉϾÍÊÇ°´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ

°´´°Ìå¿Ø¼þÉϵÄÄÚÈÝ×÷Ìõ¼þ¶ÔÊý¾Ý½øÐÐɸѡ

ÉÏÏÂÎÄÊÇʲô£¿

¡°°´´°Ìåɸѡ¡® Õâ¸öÊõ ......
×ܼǼÊý:990; ×ÜÒ³Êý:165; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [135] [136] [137] [138] 139 [140] [141] [142] [143] [144]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ