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

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


Ïà¹ØÎÊ´ð£º

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

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

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

aspÁ¬½ÓACCESSÊý¾Ý¿âµÄÎÊÌ⣡£¡

×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡­¡­
xx.aspΪ£º
<html>
<hea ......

ÈçºÎÐÞ¸ÄACCESSϵͳ±í

ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É

²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£

ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...

лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......

£¨ÔÚÏߵȴý£©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ºÅ