Access Êý¾ÝÉýǨµ½ SQLServer2005
ÎÒÔ±¾ÊÇÓÃACCESSµÄÊý¾Ý¿â£¬ÏÖÔÚ¸ÄÓÃSQLServer2005ÁË£¬ËùÒÔÏë°Ñ֮ǰµÄÊý¾ÝÈ«¶¼µ¼µ½SQLSERVERÀïÀ´¡£ ÏÖÓÐÎÊÌâÈçÏ£º 1:¸ÄÓÃSQLserverºó£¬Êý¾Ý¿âµÄ½á¹¹Óи͝¡£Ô±¾ÔÚaccessÖÐËùÓеĵ¥¾ÝÓÃÒ»¸ö¡°µ¥¾ÝÐÅÏ¢¡±Ö÷±íºÍÒ»¸ö¡°µ¥¾ÝÃ÷ϸ¡±´Ó±íÀ´´æ´¢£¬SQLSERVERÖзֳÉÁË¡°·¢»õµ¥¾Ý¡±¡¢¡°·¢»õµ¥¾ÝÃ÷ϸ¡±¡¢¡°Èë¿âµ¥¾Ý¡±¡¢¡°Èë¿âµ¥¾ÝÃ÷ϸ¡±==¡£×ܵÄÀ´Ëµ¾ÍÊǰÑaccessÖеÄÒ»¸ö±íÔÚSQLSERVERÖвð·Ö³ÉÁ˼¸¸ö±í¡£ÔÚACCESSÖÐÊÇͨ¹ýÒ»¸öµ¥¾ÝÀàÐÍ×Ö¶ÎÀ´Çø·Öµ¥¾ÝµÄ¡£ 2£ºÖ÷±íµÄÖ÷¼üÊÇÒ»¸ö¡°×Ô¶¯±àºÅ¡±ÀàÐ͵ġ°µ¥¾Ý±àºÅ¡±×ֶΣ¬´Ó±íÖеġ°µ¥¾Ý±àºÅ¡±ÓëÆä¹ØÁª¡£Õâ¸öÔÚµ¼ÈëSQLSERVERµÄ¹ý³ÌÖÐÓ¦¸ÃÔõô´¦Àí?ÊDz»ÊÇÓ¦¸ÃÔÚµ¼ÈëµÄ¹ý³ÌÖж¯Ì¬µÄ»ñÈ¡Ö÷±íÖмǼµÄ¡°×Ô¶¯±àºÅ¡±£¬ÔÙµ¼ÈëÃ÷ϸʱдÈëÏàÓ¦µÄ×ֶΣ¿ 3£º»¹ÓиöÎÊÌâ¾ÍÊÇ£¬SQLSERVERÖеıí±ÈACCESSÖеıíÀ©³äÁËЩ×ֶΡ£±ÈÈç: ACCESS: ÈËÎï±í£º ÐÕÃû¡¢ÄêÁä¡¢ÐÔ±ð SQLSERVER: ÈËÎï±í£º ÐÕÃû¡¢Éí¸ß¡¢ÌåÖØ¡¢ÄêÁ䡢ѧÀú¡¢ÐÔ±ð¡¢ÈËÆ·¡¢°®ºÃ Ò²¾ÍÊÇ˵ACCESSÖÐÓеģ¬SQLSERVERÖж¼ÓУ¬µ«SQLSERVERÖжàÁËЩ×ֶΣ¬²¢ÇÒ´òÂÒÁËÔÀ´×ֶεÄ˳Ðò£¬ÒòΪÓвåÈëµÄÏÖÏó¡£ Õâ¸öÓ¦¸ÃÊÇÓô洢¹ý³ÌÀ´×ö°É£¿Ç뾡Á¿ËµµÄÏêϸЩ£¬SQLÓï¾ä×îºÃÓб¸×¢¡£ ÁíÍ⻹ÓÐʲôÐèÒªÎÒÌṩµÄÐÅÏ¢ÇëÖ¸³ö¡£ лл
ÓÃÊý¾Ýµ¼Èëµ¼³ö¿ÉÒÔ½â¾ö1ºÍ3¡£Ð´ÏàÓ¦µÄ²éѯÓï¾ä¾Í¿ÉÒÔÁË¡£ dts ´´½¨ SSIS °ü½øÐÐÊý¾Ý³éÈ¡¡¢×ª»»¡¢×°ÔØ£¨ETL£©¡£ÒýÓà 1.µ¼Êý¾Ý¿ÉÒÔÓÃSQL×Ô´øµÄ¹¤¾ß¡£ 2.¹ØÓÚÖ÷ÖØ±í£¬Èç¹û²»Ïë¸ÄÔÓеijÌÐò£¬×îºÃÓÃÔÓеĽøÐйØÁª£¬·ñÔòÖØÐÂÖØ³É¹ØÁª¡£ 3.¹ØÓÚµÚÈý¸öÎÊÌ⣬½¨ÒéдÔÚ´æ´¢¹ý
Ïà¹ØÎÊ´ð£º
mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ ±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£© ûÓС£ ³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£ ½èÖúÆäËûÓïÑÔ Ä¿Ç°µÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£
......
strSQLCmd.Format(_T("select * from (select * from talk_info where %s ='%s') where %s ='%s'"), strVar,strValue,strVar2,strValue2); ÇëÎÊÕâÓï¾äÓÐÎÊÌâÂð ûÓÐÎÊÌâ¡£ ......
н¨µ¥Îĵµ³ÌÐòÑ¡ÔñODBCÖеÄÊý¾ÝԴʱ×ÜÊǵ¯³öÒ»¸öµÇ¼´°¿ÚÒªÊÚȨ¡£¡£¡£»¹ÒªÃÜÂë¡£¡£¡£ ÆäËûµÄµ÷ÓÃODBCÖеÄÊý¾ÝÔ´ÊǾͲ»ÐèÒªÕâ¸ö£¬¿ÉÒÔÔËÐС£ ŪÁ˺ó¤Ê±¼äÁË¡£¡£¡£ ûÓö¼û¹ý£¬¿ ......
Çë¸øÒ»¸öACCESS¶àÌõ¼þ²éѯµÄÀý×Ó,×Ö¶Î:ÐÕÃû,µç»°,¹«Ë¾,µØÖ·Îª²éѯÌõ¼þ,Ö»Òª²»Îª¿Õ,¾Í×÷Ϊ²éѯÌõ¼þ. ÄãÏÈ給這個Щ×Ö¶Î設ÖÃ變Á¿並賦³õÖµ為:%, ÔÙÔÚ²é詢 ......
access vba ÖÐÔõôȡµÃÊý×鳤¶È£¿ Êý×éÐУ¿ UBound(Êý×éÃû) ubound()-lbound() UBound º¯Êý ·µ»ØÒ»¸ö Long ÐÍÊý¾Ý£¬ÆäֵΪָ¶¨µÄÊý×éά¿ÉÓõÄ×î´óϱꡣ Óï·¨ ......