¹ØÓÚACCESSºÍMSSQLµÄÎÊÌâ - Web ¿ª·¢ / ASP
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒҲѧϰÏÂ~
¿ÉÄÜ Óв¿·ÖÊý¾Ý ±»¶ñÒâ×¢Èë ºÜ¶àÐÅÏ¢ ÇëÄã²é¿´Ò»Ï »òÕßÄãsqlÓï¾ä ²éһϠÓÐûÓÐʲô ²»·ûºÏÒªÇóµÄÐÅÏ¢´æÔÚ
û¼û¹ýÕâÑùµÄÎÊÌ⣬°ï¶¥
¹À¼Æ´æÁ˱¸·ÝÐÅÏ¢
ûÓжñÒâÐÅÏ¢£¬ÆÚ´ý¸ßÊÖÖ¸µã
ÓÃaccess2007´ò¿ªÊý¾Ý¿â£¬µã×óÉϽǵÄoffice°´Å¥£¬Ñ¡¹ÜÀí->ѹËõºÍÐÞ¸´Êý¾Ý¿â
°ï¶¥Ñ§Ï°¡«¡«¡«¡«¡«¡«¡«¡«
Ó¦¸ÃÊÇÓÐtext×ֶεÄÄÚÈݹýÓÚÅòÕÍ£¬Äã¿ÉÒÔ½«Ã¿¸öÊý¾Ý±íµ¼³öµ½excelÎļþ£¬È»ºó·Ö±ð²é¿´´óС¿ÉÅжÏÊÇÄÄÀïµÄÎÊÌâÁË¡£
²¹³ä£ºÊÇ·ñÄãÔÚÉè¼ÆÊý¾Ý¿âµÄʱºò×Ö¶ÎÀàÐÍÉè¼ÆÌ«´ó¡£
ѧϰѧϰ!!!!!!!!!!
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
ÒÑÖªÁ½¸öÊý¾Ý¿â£¬·Ö±ðΪBASE.MDB ºÍ BASE2.DBF
×ֶηֱðΪBASE.MDB:NAME NAME2 NAME3
A B C
D E F
......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......