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

Accessµ¼³öµ½Excel±í¸ñÖ»Äܵ¼Ç°15ÁеÄÎÊÌâ

aspµ¼³ö´úÂ룺

Dim App,Book,Shts,Sht
set App = CreateObject("Excel.Application")
App.DisplayAlerts = false
App.Application.Visible = false

App.WorkBooks.add
set Book = App.ActiveWorkBook
set Shts = Book.Worksheets
set Sht = Book.Sheets(1)

Sht.Range("A1:O1").Value = Array("µÚ1ÁÐ", "µÚ2ÁÐ", "µÚ3ÁÐ", "µÚ4ÁÐ", "µÚ5ÁÐ", "µÚ6ÁÐ",  "µÚ7ÁÐ", "µÚ8ÁÐ", "µÚ9ÁÐ", "µÚ10ÁÐ", "µÚ11ÁÐ","µÚ12ÁÐ","µÚ13ÁÐ","µÚ14ÁÐ","µÚ15ÁÐ","µÚ16ÁÐ","µÚ17ÁÐ")
Dim r 'ÐÐÊý
r=2  '´ÓµÚ¶þÐпªÊ¼Ð´
Dim DeferOctEmp,IsCheck
do while not rs.eof
  Sht.Range("A"&r&":O"&r).Value=Array(rs("a"), rs("b"), rs("c"), rs("d"), rs("e"), rs("f"), rs("g"), rs("h"), rs("i"), rs("j"), rs("k"), rs("l"), rs("m"), rs("n"), rs("o"), rs("p"), rs("q"))
rs.movenext
r=r+1
loop
rs.close
set rs=nothing

Äܽ«Êý¾Ýµ¼³öÀ´£¬µ«Ææ¹ÖµÄÊÇÖ»Äܵ¼³öǰ15ÁУ¨Ö»µ½¡°µÚ15ÁС±£©µÄÊý¾Ý£¬ºóÃæµÄ16¡¢17¶¼Ã»ÓÐÁË£¬¸ßÈ˴ͽÌÈçºÎÄܰÑËùÓÐÁеÄÊý¾Ý¶¼µ¼³öÀ´¡£¡£¡£¸Ð¼¤²»¾¡
Ëæ±ãÀ´¸ö  ÂíÉϸø·


Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

ACCESSÊý¾Ý¿âÓëVB¿ª·¢µÄÈí¼þ½øÐл¥Á¬ÍøÁ¬½Ó

±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬

ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ
Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ
http://downlo ......

ACCESSµÄ×Ô¶¨Ò庯ÊýÔÚdelphiÀïÔõôÓÃÄØ...

ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()

¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...

Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!


(ÔÚA ......

access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì

access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»
ÒýÓÃ
access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»

Èç¹ûÖ»Êǵ¼Êý¾Ý,ʹÓÃDTS»òSSISµ¼Èë¼´¿É,ûʲôÏêϸ¹ý³Ì,°´ÕÕ½çÃæÒ»²½Ò»²½×ß¼´¿É.

DTS ²»Ê ......

ÈçºÎ½«oracle±íת»»³ÉAccessÎı¾Îļþ

ÈçºÎ½«oracle±íת»»³ÉAccess±í»òÎı¾Îļþ
´ó¸ç¼±°¡¡£¡£
¿´ÄãÓÃʲô¹¤¾ß¡£ÓÃtoadÖ®ÀàµÄµ¼³ö¿ÉÒÔÑ¡Ôñµ¼³ö¸ñʽ¡£
ÓÃsqlplus¿ÉÒÔspool

·½·¨ºÜ¶à.
¿ÉÒÔÓÃpl/sql developer°Ñ±í±£´æÎªexcel,ÔÙ°Ñexcelµ¼Èëµ½ac ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ