Accessµ¼³öEXCEL£¬¹ØÓÚ×Ö¶ÎÃûÏÔʾÔÚÁÐÏò
Çë´ó¼ÒÖ§³Ö£¬Ð»Ð»-³õ¼¶AccessÓû§¡£ Ŀǰµ¼³öµÄÊý¾ÝÈçÏ£º ×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3 A B C ÎÒ¿ÊÍûʵÏÖµ¼³öÀ´µÄ¸ñʽΪ ×Ö¶Î1 A ×Ö¶Î2 B ×Ö¶Î3 C ÎļþÒÑÉÏ´« http://access911.net/csdn/FileDescription.asp?mdb=2010-1-21&id=36
select '×Ö¶Î1',×Ö¶Î1 from tt union select '×Ö¶Î2',×Ö¶Î2 from tt union select '×Ö¶Î3',×Ö¶Î3 from tt ×ÔÐÐÐÞ¸ÄÒýÓà VB codePrivateSub Command91_Click()OnErrorGoTo Err_Command91_ClickDim oAppAsObjectSet oApp=CreateObject("Excel.Application") oApp.Visible=True oApp.Workbooks.Add oApp.cells(1,1)="Project N?- лл£¬ÒѾʵÏÖÁË ÁíÎÊ£ºÇëÎÊÈçºÎ¿ÉÒÔÉèÖõ¼³öµ½ExcelÀïµÄ×ÖÌ壬ÒÔ¼°ÔÚµ¥Ôª¸ñÊÇ·ñ¾ÓÖлòÕ߯«×óʲôµÄ£¬ÒÔ¼°Èç¹ûÎÒÏë¸øµÚÒ»ÁеÄÑÕɫĬÈÏΪ»ÒÉ«£¬ÇëÎÊÔÚÖмä¸Ã¼ÓÈëÄÄЩ´úÂëÄØ£¿ ÎÒÒѾÃþË÷µ½ÈçºÎ½â¾öÁË£¬ÏȽáÌùºÇºÇ£¬Ð»Ð»Á˸÷λ
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿ ´ó¼ÒÖªµÀÂð? ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷ ¾Ù¸öÀý×Ó£º ¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺 ÊÇtextÐ͵ÄÊý×Ö£ºÈç 1101 1102 1103 µÈ£¬ ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺ ×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏ HTTP Status 500 - ------------------------------------------------------------------------------- ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
±¾ÈËÊǸÕѧϰDelphi×Å£¬ÏÖÓöµ½ÈçÏÂÒ»¸öÎÊÌ⣺ ÎÒÏëÔÚListBoxÖÐÏÔʾAccessÊý¾Ý¿âTB±íµÄPeople×Ö¶ÎÀïÃæµÄ¼Ç¼¡£ ÀýÈ磺 TB±íÖеÄ×Ö¶ÎPeopleÀïÃæ¼Ç¼£ºA,B,C,D...... ÔÚListBoxÖÐÏÔʾ£¬ListBox.Item[0]:=A ......