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

ACCESS ²»Í¬±íºÏ²¢ÁÐÎÊÌâ Çë¸ßÊֻشðлл

ÎÒÏë°ÑACCESS Öеıí1 AÁÐÊý¾Ý ºÍ ±í2 µÄCÁÐÊý¾Ý ºÍ²¢µ½ ±í3 ÔõôÓÃSQL½â¾ö ¾ßÌåÈçÏ£º
±í1
AÁР BÁÐ
1    ´ó
2    ÖÐ
3    С
±í2   
CÁР DÁÐ
A    a
B    b
C    c
SQL½á¹û£º
±í3
AÁР CÁÐ
1    A
2    B
3    C
±í1,±í2 Èç¹ûûÓÐÈκιØÁª×ֶΣ¬»òÕßÅÅÐò×ֶΣ¬ÔòûÓа취¡£

Êý¾Ý¿âÖеļǼÂß¼­ÉÏÊÇûÓÐ˳ÐòµÄ£¬ËùÒÔÄãµÄÒªÇó±È½ÏÄѽöͨ¹ýSQLÓï¾äÀ´ÊµÏÖ¡£ ¿ÉÒÔʹÓÃVBA¡£

Èç¹ûÓйØÁª×Ö¶ÎÄØ£¬±ÈÈç±àºÅ

ÒýÓÃÈç¹ûÓйØÁª×Ö¶ÎÄØ£¬±ÈÈç±àºÅ


½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£

select * from ±í1 inner join ±í2 on ±í1.±àºÅ =±í1.±àºÅ

ºÇºÇ£¬À÷º¦£¬²âÊԳɹ¦ÁË£¬Ð»Ð»


Ïà¹ØÎÊ´ð£º

ÇóACCESSÊý¾Ý¿â

      ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
  ¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË

officeÍêÕ ......

ÈçºÎ½«XMLÊý¾Ý´æÈëACCESSÊý¾Ý¿â

ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:

<?xml version="1.0" encoding="utf-8"? ......

vb.net ´´½¨accessÊý¾Ý±íʵÏÖÒ»Êý¾Ý¿â¶à¸öÊý¾Ý±í£¿

Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......

½â¾ö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 ......

jspÒ³Ãæµ¼³öÎÊÌ⣿ÄÜ·ñµ¼³öΪDBFºÍACCESS¸ñʽµÄÎļþ

jsp¿ª·¢µÄʱºòÄܹ»µ¼³öwordºÍexcel£¬µ«ÊÇÊÇ·ñÄܹ»Ö±½Óµ¼³öΪacess¸ñʽ¡¢dbf¸ñʽµÄÎļþ£¿
¸ßÊÖÖ¸µãÏ£¬×îºÃÄܹ»¸ø¸öÀý×Ó£¬Ð»Ð»£¡£¡£¡

javadbfÕâ¸öjarÒ»ÇÐÎÊÌâ½â¾öÁË¡£
ÏÂÔØµØÖ·Îª£ºhttp://sarovar.org/projects/ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ