AccessÖеİ´´°ÌåɸѡÊÇʲôÒâ˼£¿
AccessÖеİ´´°ÌåɸѡÊÇʲôÒâ˼£¿
Me.´æÊé²éѯ×Ó´°Ìå.Form.Filter = strWhere
Me.´æÊé²éѯ×Ó´°Ìå.Form.FilterOn = True
ʵ¼ÊÉϾÍÊǰ´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ
ʵ¼ÊÉϾÍÊǰ´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ
°´´°Ìå¿Ø¼þÉϵÄÄÚÈÝ×÷Ìõ¼þ¶ÔÊý¾Ý½øÐÐɸѡ
ÉÏÏÂÎÄÊÇʲô£¿
¡°°´´°Ìåɸѡ¡® Õâ¸öÊõÓïû¼û¹ý¡£
Ïà¹ØÎÊ´ð£º
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ЩÁËÒ»¸ö¼òµ¥ÍøÕ¾£¬ÓõÄÊÇaccessÊý¾Ý¿â£¬·¢²¼µ½ÓòÃû¿Õ¼äÉÏÈ¥ºó£¬¿ª³¡Ò³ÏÔʾÕý³££¬ÆäÓà´æÔÚÊý¾Ý¿âÁ´½ÓÊý¾ÝµÄÅ׳öÒì³££¬
Ìáʾ£º'c:\windows\system32\inetsrv\data\longdeng.mdb'²»ÊÇÒ»¸öÓÐЧµÄ·¾¶¡£ È·¶¨ ......
°¦£¬ÓÉÓÚ²»É÷£¬²Ù×÷´ò°üÈí¼þµÄʱ¼ä°ÑÎÒ×öµÄϵͳŪ¶ªÁË£¬ÕæÊÇÎÞÄΣ¬ÏÖÔÚÓгöÏÖеÄÎÊÌâÁË£¬ÒÔǰ»¹ºÃºÃµÄ£¬ÕâÊÇÎÒ½«ECXELµ¼ÈëACCESSµÄ´úÂë¡£
Private Sub Command1_Click()
ExportExcelSheetToAccess " ......
Ë×ö¹ýÕâ·½ÃæµÄ,°ÝÇó..ÌáÐÑÒ»ÏÂ,ÎÒËùÓеķֶ¼ËÍÄã~~~~
Ö±½ÓºÍµ÷ÓñíÏàͬ¡£
select * from table1
select * from qeury1
ÒýÓÃÌáÐÑÒ»ÏÂ,ÎÒËùÓеķֶ¼ËÍÄã~~~~
( ¿ÉÐŶȲ»¸ß°¡)
Liang4 (Á ......