![[CX's MEMO]](image/cx_memo.jpg "[CX's MEMO]")
20040915.zip' MatchData.vbs
' Usage : CScript MatchData.vbs
Const strFileName1 = "D:\home\edu\hatena\20040915\db1.xls" ' table1 として利用
Const strFileName2 = "D:\home\edu\hatena\20040915\db2.xls" ' table2 として利用
Const strFileName3 = "D:\home\edu\hatena\20040915\db3.xls" ' table3 として利用
MatchData
Sub MatchData
Dim cn
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFileName3 & ";Extended Properties=Excel 8.0"
Dim strSQL
strSQL = "INSERT INTO [Sheet1$]" & _
" SELECT t2.c1, t2.c2, t2.c3, t2.c4, t2.c5" & _
" FROM [Excel 8.0;database=" & strFileName1 & "].[Sheet1$] AS t1" & _
" INNER JOIN [Excel 8.0;database=" & strFileName2 & "].[Sheet1$] AS t2" & _
" ON (t1.c3 = t2.c3) AND (t1.c2 = t2.c2) AND (t1.c1 = t2.c1)"
cn.Execute strSQL
End Sub[table1]
c1 c2 c3 c4 c5
あ い う ※ △
か き く ○ ◆
さ し す × ◇
[table2]
c1 c2 c3 c4 c5
あ い う × ○
か き く を ■
さ し す ヾ 〒
た ち つ ‖ 〆
な に ぬ 仝 ±
[table3]
c1 c2 c3 c4 c5
[結果]
c1 c2 c3 c4 c5
あ い う × ○
か き く を ■
さ し す ヾ 〒
INSERT INTO
table3
SELECT
table2.c1,
table2.c2,
table2.c3,
table2.c4,
table2.c5
FROM
table1
INNER JOIN
table2
ON
(table1.c3 = table2.c3)
AND (table1.c2 = table2.c2)
AND (table1.c1 = table2.c1);
http://www.sales.mx/lisinopril-hydrochlorothiazide-20-125-mg.pdf#bonfire lisinopril for high blood pressure side effects According to property finders Garrington, house prices in Hackney (11 per cent), Camden (10.6 per cent) and Merton (10 per cent) have all increased more in the past year than traditionally well-heeled areas such as Westminster (6.9 per cent). http://www.opm.gov.dm/index.php/robaxin-750-recommended-dosage.pdf#runner how much does robaxin cost Inflation was low in the months prior to the meeting, with the trends in all broad measures remaining below the Committee's 2 percent longer-run objective. Several transitory factors, including a one-time reduction in Medicare costs, contributed to the recent very low inflation readings. In addition, energy prices declined, and nonfuel commodity prices were soft. Over the past year, both core and overall consumer price inflation trended lower; participants cited various alternative measures of consumer price inflation, including the trimmed mean PCE and CPI as well as the sticky price CPI, that suggested that the slowing was broad based. Market-based measures of inflation expectations decreased over the intermeeting period but remained within their ranges over the past few years. Most participants expected inflation to begin to move up over the coming year as economic activity strengthened, but many anticipated that it would remain below the Committee's 2 percent objective for some time. One participant expressed concern about the risk of a more rapid rise in inflation over the medium term, given the highly accommodative stance of monetary policy. In contrast, many others worried about the low level of inflation, and a number indicated that they would be watching closely for signs that the shift down in inflation might persist or that inflation expectations were persistently moving lower. http://www.centrumjudaicum.de/cjudaicum_wp/diflucan-for-yeast-infection-on-skin.pdf how long to take diflucan for ringworm Relations between China and Japan, the world's second- and third-largest economies, have been troubled in recent years by a row over tiny, uninhabited islands in the East China Sea known as the Senkaku in Japan and the Diaoyu in China. http://it-data-storage.co.uk/can-gabapentin-cause-erectile-dysfunction.pdf can gabapentin cause erectile dysfunction â??The reasons for that are obviously complex and relate to the whole system of care within the hospital. They relate to emergency medicine, they relate to the admissions coming through the A&E department. http://www.colonialredirecord.com/vigorcare-side-effects.pdf vigorcare home health "The Gospel is for everyone, not just for some," Francis said while celebrating Mass for more than 3 million Catholics crowding Copacabana beach. "Do not be afraid to go and to bring Christ into every area of life, to the fringes of society, even to those who seem farthest away." -- Stacy? 2017-02-21 (火) 14:47:01 http://oxfordcitystars.com/macrobid-100mg-tablets.pdf#whirl macrobid 100mg side effects The battle up front will be key for their chances so Kieran Brookes, returning home from Leicester Tigers, will need to put in a good shift. Add all that together, and they will not be relegated. http://bussipark.ee/urimax-f-price.pdf#owen urimax tablet india Interestingly, a big reason the emerging markets have plunged (especially as of late) is because of concerns that the next moves by the Fed will lead to massive outflows of capital from these developing nations. India, Brazil and others have large current account deficits. http://bellegreyedesigns.com/propecia-finasteride-price.pdf#urgently propecia tablets for hair loss Since his transplant, Mr Burbedge has won two gold medals for Team GB in the European Heart and Lung Transplant Games and is competing again this year, and last July he carried the Olympic Torch through Reading. http://www.hospiciolafe.com/l-arginine-for-peyronies-disease.pdf#fierce is l-arginine safe for high blood pressure This year's field includes past winners of both the Spartathlon, the 246-kilometer Greek race held annually between Athens and Sparta, and the notorious Badwater Ultramarathon, the self-styled "world's toughest foot race" over 217 kilometers through California's Death Valley. http://suricog.fr/index.php/5-permethrin-cream-video.pdf 5 permethrin cream video In addition, researchers who receive NIH funding will be expected to deposit further sequencing data from HeLa cells into an NIH database that scientists will access through this process. They will also be asked to include in their publications and presentations "an acknowledgement and expression of gratitude to the Lacks family," NIH said, much as they acknowledge their source of funding. -- Mitch? 2017-02-21 (火) 14:47:51
