Çë½Ì¹ØÓÚACCESSÁ¬½ÓSQLµÄÎÊÌâ
֮ǰÓÃACCESS×öµÄÒ»¸öϵͳ£¬ÏÖÔÚ½«±í¶¼×ªµ½SQLÀȻºóÓÃODBCÁ¬½ÓSQL±í¡£
ÏÖÔÚÓиöÎÊÌâ¾ÍÊÇ£¬ÎÒÆäÖÐÓÐÒ»¸ö±íµÄÊý¾ÝÊÇ´ÓEXCELÀïµ¼ÈëµÄ£¬Èç¹û±íÔÚACCESS±¾µØµ¼ÈëÕý³££¬ÏÖÔÚÓÃÁ´½Ó±íµ½SQL£¬µ¼ÈëʱÌáʾ³É¹¦£¬µ«±íÄÚÎÞÊý¾Ý£¿
ÇëÎÊÊDz»ÊDz»Ö§³ÖÁ¬½Ó±íµ¼ÈëÊý¾ÝÄØ£¿»¹ÊÇÒª¸Äµ¼Èë³ÌÐò£¿
ʹÓõ¼Èëµ¼³ö£¬°ÑÊý¾Ýµ¼Èëµ½sql
Äܹ»¾ßÌåÒ»µãÂð£¿ÎÒÊÇÔÚACCÀïÓÃVBA´úÂëµ¼ÈëµÄ¡£
ÄãÊÇÈçºÎ½øÐе¼Èë¡£ ACCESSÖ§³ÖÁ´½Ó±íµ¼Èë¡£
ÓÃVBA´úÂëµ¼ÈëµÄ°¡
accessÁ´½Ó±íµ¼ÈëÎÒÊÔ¹ýûÎÊÌâµÄ£¬ÏÖÔÚÎÒÔÚaccessÀïÓÃODBCÁ¬½ÓSQL±í£¬µ¼Èë¾Í²»ÐÐÁË£¬µ¼ÈëÍêºóµ«±íÄÚÎÞÄÚÈÝ¡£
·¹ý¡£¡£¡£¡£Ã»ÓÐʵ¼Ê¾Ñé
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æʱ¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......