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

ACCESSÊý¾Ýµ¼ÈëµÄÎÊÌâ!

ÈçÌâ,ÐèÒª½«ÏÂÃæµÄexcelÊý¾ÝÈ«²¿µ¼Èëµ½ACCESSÖÐ
[IMG]http://i441.photobucket.com/albums/qq133/gsy67618p2p/1-1.jpg[/IMG]

ͨ¹ýACCESS×Ô´øµÄÏòµ¼¹¦ÄÜ¿ÉÒÔʵÏÖ,µ«ÊDzÙ×÷ÆðÀ´Ì«Âé·³,Ïëͨ¹ý½¨Á¢²éѯÀ´µ¼Èë,¿ÉÊǵ¼ÈëÒԺ󲿷ÖÊý¾Ý½ø²»È¥,ÈçÏÂ:
[IMG]http://i441.photobucket.com/albums/qq133/gsy67618p2p/2-2.jpg[/IMG]


ÎÒÓõÄÊÇ
INSERT INTO sheet6 ( name )
SELECT »úÆ÷´úÂë
from [sheet1$] IN 'c:/xz.xls'[Excel 8.0;];


ÇëÎÊÓÐûÓкÍACCESS×Ô´øµÄÏëµ½¹¦ÄÜÒ»ÑùµÄÓï¾ä,ʵÏÖexcel±íµ¥Êý¾ÝµÄÎÞ²î±ðµ¼ÈëÄØ?



ͼƬÔÚÕâ

ûÈËÀ´À²
ûÓÐÓï¾äÒ²¿ÉÒÔ  Ìṩһ¸öÒ»¼üʵÏÖACCESSµ¼È빦Äܵķ½·¨Ò²Ðа¡


ÒýÓÃ
cstr(»úÆ÷´úÂë)  ÊÔÊÔ



ºÇºÇ ²»ÐÐ ²»¹ýÎÒ½â¾öÁË

ÐèÒª¼ÓÈëIMEX


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

´íÎóÐÅÏ¢Access violation....

ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......

ACCESSÊý¾Ý¿âתDBF

ÒÑÖªÁ½¸öÊý¾Ý¿â£¬·Ö±ðΪBASE.MDB ºÍ BASE2.DBF
×ֶηֱðΪBASE.MDB:NAME NAME2 NAME3 
  A B C  
  D E F  
  ......

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

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

javadbfÕâ¸öjarÒ»ÇÐÎÊÌâ½â¾öÁË¡£
ÏÂÔØµØÖ·Îª£ºhttp://sarovar.org/projects/ ......

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

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