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£©¡£
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
н¨µ¥Îĵµ³ÌÐòÑ¡ÔñODBCÖеÄÊý¾ÝԴʱ×ÜÊǵ¯³öÒ»¸öµÇ¼´°¿ÚÒªÊÚȨ¡£¡£¡£»¹ÒªÃÜÂë¡£¡£¡£
ÆäËûµÄµ÷ÓÃODBCÖеÄÊý¾ÝÔ´ÊǾͲ»ÐèÒªÕâ¸ö£¬¿ÉÒÔÔËÐС£
ŪÁ˺ó¤Ê±¼äÁË¡£¡£¡£
ûÓö¼û¹ý£¬¿ ......
ÓõÄÊÇ2008дÁËÒ»¶ÎÅжÏÊý¾Ý¿âDbNameÖÐÊÇ·ñÓбíTabNameµÄ³ÌÐò£¬µ«ÊÇÔÚµ÷ÓõÄʱºò³öÏÖÁËÊý¾Ý¿âÃû³Æ²»ÄÜת»»ÎªDoubleÐÍÊý¾ÝµÄÎÊÌ⣬µ«ÊÇÔÚÕâµ±ÖÐÎÒ¸ù±¾Ã»ÓÐÉèÖÃDoubleÐÍÊý¾Ý£¬¸Õ¿ªÊ¼½Ó´¥VB.net£¬²»ÊǺܶ®£¬´ó¼Ò°ïæ°¡ ......
¸÷λ´óÏÀ£º
ÔÚ´°ÌåÀïÓÐÒ»Áбí¿ò£¬ÃûÔ»¡°ÉÌÆ·±àºÅ¡±£¬ÐÐÀ´Ô´ÀïµÄÄÚÈÝÓУºÉÌÆ·±àºÅºÍÉÌÆ·Ãû£¨À´×ÔÉÌÆ·±í£©¡£
µ«ÊÇÎÊÌâ³öÏÖÁË£ºÔÀ´ÉÌÆ·±íÀïµÄÉÌÆ·±àºÅÊÇ4λ£ ......
Ò»¸ö³ÌÐòÍùaccessÊý¾Ý¿âÀïÃæд¼Ç¼£¬Ã¿Ììд5ÍòÌõ£¬µÚ¶þÌìɾ³ýÇ°Ò»ÌìµÄ5ÍòÌõ
µ«ÊÇaccessÎļþµÄÌå»ý»áÂýÂýÔö¼Ó¡£¡£¡£
ÎÒ²»Ñ¹ËõÊý¾Ý¿âµÄÇé¿öÏ£¬Ê²Ã´Ê±ºòÊý¾Ý¿âµÄÌå»ý²Å²»Ôö¼ÓÄØ£¿
ÎÒɾ³ý¼Ç¼µÄʱºò£¬Êý¾Ý¿âÌå ......