Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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µÄÏûÏ¢´«µÝ¹¦ÄÜ

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£©

ûÓС£

³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£

½èÖúÆäËûÓïÑÔ

ĿǰµÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£ ......

ÔÚÒ»ÕÅaccess±íÖÐǶÌײéѯ

strSQLCmd.Format(_T("select * from (select * from talk_info where %s ='%s') where %s ='%s'"),
strVar,strValue,strVar2,strValue2);
ÇëÎÊÕâÓï¾äÓÐÎÊÌâÂð
ûÓÐÎÊÌâ¡£
......

ODBC Microsoft accessµÇ¼ʧ°Ü

н¨µ¥Îĵµ³ÌÐòÑ¡ÔñODBCÖеÄÊý¾ÝԴʱ×ÜÊǵ¯³öÒ»¸öµÇ¼´°¿ÚÒªÊÚȨ¡£¡£¡£»¹ÒªÃÜÂë¡£¡£¡£
      ÆäËûµÄµ÷ÓÃODBCÖеÄÊý¾ÝÔ´ÊǾͲ»ÐèÒªÕâ¸ö£¬¿ÉÒÔÔËÐС£
  ŪÁ˺ó¤Ê±¼äÁË¡£¡£¡£
ûÓö¼û¹ý£¬¿ ......

Çë¸øÒ»¸öACCESS¶àÌõ¼þ²éѯµÄÀý×Ó

Çë¸øÒ»¸öACCESS¶àÌõ¼þ²éѯµÄÀý×Ó,×Ö¶Î:ÐÕÃû,µç»°,¹«Ë¾,µØÖ·Îª²éѯÌõ¼þ,Ö»Òª²»Îª¿Õ,¾Í×÷Ϊ²éѯÌõ¼þ.
ÄãÏÈ給這個Щ×Ö¶Î設ÖÃ變Á¿並賦³õÖµ為:%,
ÔÙÔÚ²é詢 ......

access vba Êý×鳤¶È

access vba ÖÐÔõôȡµÃÊý×鳤¶È£¿
Êý×éÐУ¿
UBound(Êý×éÃû)

ubound()-lbound()

UBound º¯Êý
     

·µ»ØÒ»¸ö Long ÐÍÊý¾Ý£¬ÆäֵΪָ¶¨µÄÊý×éά¿ÉÓõÄ×î´óϱꡣ

Óï·¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ