Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

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

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......

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

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