Ķĥ襷֥ ޥӥ󥿤

TESTACH Υե졼ȤɥХ˾äƤޤƥʥ󥹤ȤȤ
PICޥȤäŻҹͥư饸إꡢWindowsץꥱȯȤ鲿Ǥ褻븫ʤblog֥ȥ 襷򤿤

2006ǯ05

Excel VBA + ADO

⤪ŻǤ

뤿ˡVBAȤäƤߤ褦ȻפäꤷΤǤ
ADOConnection.OpenǸߤΥȤ򳫤SELECTINSERT򤷤ޤäƤPC㤯ŤʤǤϤʤǤ

Dim cn
Set cn = CreateObject("ADODB.Connection")
cn.Open "driver=Microsoft Excel Driver (*.xls);DBQ=" & ThisWorkbook.FullName & ";ReadOnly=False;"

ʴdzơ200勞餤ʤǡ

SELECT **** FROM ****

ȤǼФơη̤ˤä

UPDATE xxxx SET yyyy = yyyy + 1 WHERE **** = ####

¹ԤޤȤΤʤΤǤ
ޥ͡Ǹ500MBȤ񤷤Ƥ䤬ޤʽ

⤽Υ֥åĤƤǡExcelλʤȥ꤬ʤȤ󤵡
äƥХȤ㤦Ρ
ȻפäMSΥȤ˺ܤäƤޤ

http://support.microsoft.com/kb/319998/en-us

RESOLUTION
The memory used by the ADO queries cannot be reclaimed by closing and releasing the ADO objects. The only way to release the memory is to quit Excel.

If possible, query the Excel worksheet only while the file is not open in Excel.

Ҥɤ(;ա)
ȻפäɡQuery the Excel worksheet while the file is not open in Excel possible ʤΤ̤VBScriptˤ褦Ȼפޤʤ

ƤƤVBAˤ̣ۤȤɤʤä󤸤㡦()

ϤҤɤ

http://plusdblog.itmedia.co.jp/koderanoblog/2006/05/_os_aabe.html
ܤWinnyкȤơȼOS뤽Ǥ롣

ܵ
Ȥï˸ƤƤߤʤ󤸤ʤΤ
Ȥ餤Ҥɤ

ǯ٤ܵؤǤѤܻؤäƽ񤤤Ƥ뤱ɡ1ǯ̤dzȯǤOSäơġ

ޤBIOSˤ֤餯餤Ϻ󤸤ʤǤʤ

1ߤǤǶȤ줿㤱롣
ȤʤOSˤʤޤǤФäƤۤʤ

Ǥ⤽ȤĤޤǤⴰ˶ФݤȤ櫓Ǥ͡

󤭤

뤴٤īӤ򿩤äƤ顢ͤ

֥ȵν񤭴ϡ

Ȥä롣

Ȼפäȵߤ

ʿǯޤͭ
ʤʤߤϣ


᤮Ƥ
Ƥȣ֤餤᤯äƤУ

ޤޤ̤ʤȤʤΤ
ȻפäĴ٤ƤߤȾǯʤʤ鼺³Ǥ餷
褫ä褫ä

ƤʿԤʤȤʤ褦ʤΤǤʽ

PCȤߤʤλ

PCȤߤʤޤ
ȤϤޤ꤬

PCȤ줿ΤǤȤꤢڥå

ޤ: ASUS P5LD2 SE (945P)
CPU: Intel Pentium4 641+ (3.20GHz, 2MB L2 Cache, HT)
CPU顼: Scythe MINE Cooler
: PC2-5300/667 DDR2 2GB (1GB x 2, Dual channel)
HDD: HGST HDT722525DLA380 (250GB, SATA)
ӥǥ: ASUS EN7600GS SILENT (GeForce 7600 GS, 256MB, Fanless, PCI Express)

¾ʤϺޤǤΤ򤽤ΤޤήѤǤ
FDDϤ⤦ȤʤʤΤǤϤޤ
HDDSATA 80GBx2 ǥȥ饤ԥ󥰤ƤΤǡ⤽Τޤްܿ
ޥܤRAIDǽʤʤäƤߤʤΤOSǥȥ饤ԥ󥰤ƥեޥåȡ

ƤȤ˼̿ȤäȤޤʤ󤸤ǡ

ɡ

HDD1椷ĤƤޤ󤬺2ɲäƤޤ

OS󥹥ȡʤλ
Ȼפäꥫɥ꡼C,D,E,Fɥ饤֤ˤʤޤ(;)
ưɥ饤֤GäƲ(;)

ʤΤǥɥ꡼ȴOSʤޤġ

ʳäʤưꡣ
ʤ˥ɥ饤ƥѥäƤߤޤ٤ǹ⡢¾ǹˤƤ˥˥ưޤ
Ǥ3DMarkȤư饬å󥬥åʤʡʤ

ޤ

ec847fca.jpg鵢Ǥ
ϻŻҥҥҥҥ (ϡ)(Ρϡ) ҥҥҥҥ
blogˤĤ
blogϡΥۡڡƥġĤǤ⤦ǯ⤳äᥤǤ
ۡڡϤ顣
http://www31.ocn.ne.jp/~yoshio2/
2ϷǼĤ˽񤭹ȤΥȥåפ GBrDo4K0i. ѤƤޤ
GoogleAds
ǿ
Ĥä
ʤ
ʤƸä餤褯ʬʤͧãʤblogʤ
ž֥ƤȤޥ˥ɥ󥯤Ȥȥ٥顼ΡȤȤ
hazimelog
ΥˤꡢϤblogSCOTT FOIL Team IssueȤääƤȤɤޤΤʤ
Դѹ˼
ž̶֤ФƤ륢˥繥ʥꥹȡSڤHP
livedoor ץե

  • 饤֥ɥ֥