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

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ÀïµÄ×ÖÌ壬ÒÔ¼°ÔÚµ¥Ôª¸ñÊÇ·ñ¾ÓÖлòÕ߯«×óʲôµÄ£¬ÒÔ¼°Èç¹ûÎÒÏë¸øµÚÒ»ÁеÄÑÕɫĬÈÏΪ»ÒÉ«£¬ÇëÎÊÔÚÖмä¸Ã¼ÓÈëÄÄЩ´úÂëÄØ£¿

ÎÒÒѾ­ÃþË÷µ½ÈçºÎ½â¾öÁË£¬ÏȽáÌùºÇºÇ£¬Ð»Ð»Á˸÷λ


Ïà¹ØÎÊ´ð£º

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

accessÖеÄtextÐÍÊý×Ö - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......

tomcatÁ¬½ÓAccessÊý¾Ý¿âÎÊÌâ¡£ - Java / Web ¿ª·¢

¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 - 
------------------------------------------------------------------------------- ......

VCÖÐ odbc·ÃÎÊaccessÄÚ´æÔö³¤

vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......

£¨ÔÚÏߵȴý£©ListBoxÖÐÏÔʾAccessÖ¸¶¨×ֶεļǼ

±¾ÈËÊǸÕѧϰDelphi×Å£¬ÏÖÓöµ½ÈçÏÂÒ»¸öÎÊÌ⣺
ÎÒÏëÔÚListBoxÖÐÏÔʾAccessÊý¾Ý¿âTB±íµÄPeople×Ö¶ÎÀïÃæµÄ¼Ç¼¡£
ÀýÈ磺
TB±íÖеÄ×Ö¶ÎPeopleÀïÃæ¼Ç¼£ºA,B,C,D......
ÔÚListBoxÖÐÏÔʾ£¬ListBox.Item[0]:=A
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ