Dear Pak Hendrik
Terima kasih atas pencerahannya
Saya coba pahami dlu Pak....
On Friday, January 12, 2018, 3:25:15 PM GMT+7, hendrik karnadi
hendrikkarn...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Hai Kiki,
Coba Extract .zip File ini ke suatu Folder atau Sub Folder mana saja.Buka File
Consolidate (TB R_HK + Kid) krn SQL nya dibantu Mr. Kid.Hapus Tabel Hasil
Query.Klik button "Consolidate" dan lihat hasilnya.Setelah memahami cara
kerjanya, coba pindahkan beberapa filenya ke beberapa Dir:\SubDir dalam satu
komputer dan ganti <Path> dengan nama Dir:\SubDir (sesuai dengan tempat2 dimana
file2 tsb berada).
Saya blm pernah mencoba untuk beda komputer dalam satu jaringan --> silakan
dicoba dan diinfo hasilnya ke milis.
Kalau sdh berhasil baru dicoba ke file asli yang akan dicombined dengan
menyesuaikan script SQL nya (jangan lupa untuk memback up file2nya terlebih
dahulu).
Selamat mencoba.
Salam,HK
On Friday, 12 January 2018, 2:17:29 PM GMT+7, kiki tanjung
kiek...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Dear Teman Teman
Mohon bantuan dan pencerahan untuk kasus berikut :
#yiv7673001310 #yiv7673001310 -- #yiv7673001310ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7673001310
#yiv7673001310ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7673001310
#yiv7673001310ygrp-mkp #yiv7673001310hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7673001310 #yiv7673001310ygrp-mkp #yiv7673001310ads
{margin-bottom:10px;}#yiv7673001310 #yiv7673001310ygrp-mkp .yiv7673001310ad
{padding:0 0;}#yiv7673001310 #yiv7673001310ygrp-mkp .yiv7673001310ad p
{margin:0;}#yiv7673001310 #yiv7673001310ygrp-mkp .yiv7673001310ad a
{color:#0000ff;text-decoration:none;}#yiv7673001310 #yiv7673001310ygrp-sponsor
#yiv7673001310ygrp-lc {font-family:Arial;}#yiv7673001310
#yiv7673001310ygrp-sponsor #yiv7673001310ygrp-lc #yiv7673001310hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7673001310
#yiv7673001310ygrp-sponsor #yiv7673001310ygrp-lc .yiv7673001310ad
{margin-bottom:10px;padding:0 0;}#yiv7673001310 #yiv7673001310actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7673001310
#yiv7673001310activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7673001310
#yiv7673001310activity span {font-weight:700;}#yiv7673001310
#yiv7673001310activity span:first-child
{text-transform:uppercase;}#yiv7673001310 #yiv7673001310activity span a
{color:#5085b6;text-decoration:none;}#yiv7673001310 #yiv7673001310activity span
span {color:#ff7900;}#yiv7673001310 #yiv7673001310activity span
.yiv7673001310underline {text-decoration:underline;}#yiv7673001310
.yiv7673001310attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7673001310 .yiv7673001310attach div a
{text-decoration:none;}#yiv7673001310 .yiv7673001310attach img
{border:none;padding-right:5px;}#yiv7673001310 .yiv7673001310attach label
{display:block;margin-bottom:5px;}#yiv7673001310 .yiv7673001310attach label a
{text-decoration:none;}#yiv7673001310 blockquote {margin:0 0 0
4px;}#yiv7673001310 .yiv7673001310bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7673001310
.yiv7673001310bold a {text-decoration:none;}#yiv7673001310 dd.yiv7673001310last
p a {font-family:Verdana;font-weight:700;}#yiv7673001310 dd.yiv7673001310last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7673001310
dd.yiv7673001310last p span.yiv7673001310yshortcuts
{margin-right:0;}#yiv7673001310 div.yiv7673001310attach-table div div a
{text-decoration:none;}#yiv7673001310 div.yiv7673001310attach-table
{width:400px;}#yiv7673001310 div.yiv7673001310file-title a, #yiv7673001310
div.yiv7673001310file-title a:active, #yiv7673001310
div.yiv7673001310file-title a:hover, #yiv7673001310 div.yiv7673001310file-title
a:visited {text-decoration:none;}#yiv7673001310 div.yiv7673001310photo-title a,
#yiv7673001310 div.yiv7673001310photo-title a:active, #yiv7673001310
div.yiv7673001310photo-title a:hover, #yiv7673001310
div.yiv7673001310photo-title a:visited {text-decoration:none;}#yiv7673001310
div#yiv7673001310ygrp-mlmsg #yiv7673001310ygrp-msg p a
span.yiv7673001310yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7673001310
.yiv7673001310green {color:#628c2a;}#yiv7673001310 .yiv7673001310MsoNormal
{margin:0 0 0 0;}#yiv7673001310 o {font-size:0;}#yiv7673001310
#yiv7673001310photos div {float:left;width:72px;}#yiv7673001310
#yiv7673001310photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7673001310
#yiv7673001310photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7673001310
#yiv7673001310reco-category {font-size:77%;}#yiv7673001310
#yiv7673001310reco-desc {font-size:77%;}#yiv7673001310 .yiv7673001310replbq
{margin:4px;}#yiv7673001310 #yiv7673001310ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7673001310 #yiv7673001310ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7673001310
#yiv7673001310ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7673001310
#yiv7673001310ygrp-mlmsg select, #yiv7673001310 input, #yiv7673001310 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7673001310
#yiv7673001310ygrp-mlmsg pre, #yiv7673001310 code {font:115%
monospace;}#yiv7673001310 #yiv7673001310ygrp-mlmsg *
{line-height:1.22em;}#yiv7673001310 #yiv7673001310ygrp-mlmsg #yiv7673001310logo
{padding-bottom:10px;}#yiv7673001310 #yiv7673001310ygrp-msg p a
{font-family:Verdana;}#yiv7673001310 #yiv7673001310ygrp-msg
p#yiv7673001310attach-count span {color:#1E66AE;font-weight:700;}#yiv7673001310
#yiv7673001310ygrp-reco #yiv7673001310reco-head
{color:#ff7900;font-weight:700;}#yiv7673001310 #yiv7673001310ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7673001310 #yiv7673001310ygrp-sponsor
#yiv7673001310ov li a {font-size:130%;text-decoration:none;}#yiv7673001310
#yiv7673001310ygrp-sponsor #yiv7673001310ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7673001310
#yiv7673001310ygrp-sponsor #yiv7673001310ov ul {margin:0;padding:0 0 0
8px;}#yiv7673001310 #yiv7673001310ygrp-text
{font-family:Georgia;}#yiv7673001310 #yiv7673001310ygrp-text p {margin:0 0 1em
0;}#yiv7673001310 #yiv7673001310ygrp-text tt {font-size:120%;}#yiv7673001310
#yiv7673001310ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7673001310
