Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

½â¾öaccess¼¶Áª¸üÐÂÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ......

ÈçºÎ½«accessÀïÃæµÄ¸½¼þ±£´æµ½´ÅÅÌÉÏÄØ

Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit

ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......

VCÁ¬½ÓACCESSÊý¾Ý¿âÎÊÌâ - VC/MFC / Êý¾Ý¿â

ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í 
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......

AccessÑ¡ÖÐij¸ö×ֶλòÕß¶à¸öµ¥Ôª¸ñÖ®ºó¿ÉÒÔ×Ô¶¯ÇóºÍ

Çë´ó¼Ò°ï棬ÎÒÏëÔÚAccess´°ÌåÀïÃæÏÔʾ±íºó£¬Ñ¡Ôñ±íÖеÄij¸ö×ֶΣ¬¾Í¿ÉÒÔ¸ù¾ÝÑ¡ÔñµÄÕâЩµ¥Ôª¸ñÇóºÍ¡¢Ç󯽾ù£¬¾ÍÈçExcelÓÒϽÇ״̬À¸ÄÇÑù£¬ºÜ·½±ãµÄͳ¼ÆÇóºÍÇ󯽾ù£¬Ð»Ð»£¡
Äã¿ÉÒÔÓÃÒ»¸ögridview »òÕ߯äËûʲô¿Ø¼þ ¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ