[belajar-excel] Digest Number 4756

Milis Belajar Microsoft Excel Group

2 Messages

Digest #4756

1a

Re: import data file dbf ke excel by "lola loli"

2a

Re: mencari start date & Finish [1 Attachment] by "Iman Darusman" idz.iman

Messages

1a

Re: import data file dbf ke excel

Mon Apr 22, 2019 6:11 pm (PDT) . Posted by:

"lola loli"

file dengan extension dbf juga bisa di buka dengan Ms Acces

--------------------------------------------
Pada Rab, 3/4/19, hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Re: [belajar-excel] import data file dbf ke excel
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Tanggal: Rabu, 3 April, 2019, 10:04 AM


 









Seingat saya file .dbf bisa juga dibuka dengan
Excel 2003..
Salam,HK
Sent
from Yahoo Mail on Android
On Wed, Apr 3, 2019 at
4:32, 'Mr. Kid' mr.nmkid@gmail.com
[belajar-excel]<belajar-excel@yahoogroups.com>
wrote:
 









Mungkin FoxPro.Coba install
vfp9 data provider (pilih yang oledb kalau ada) di office 32
bit.Lalu manfaatkan fitur get external data from
data connection wizard pilih other/advanced, pilih provider
visual foxpro yang baru di-installke tab
Connection -> pilih database, pilih opsi free table ->
pilih file dbf nya -> pilih kemana akan ditampilkan (bisa
jadi pivot table langsung atau diletakkan dalam
worksheet).
*** tidak
ada vfp yang 64 bit ya, jadi tidak bisa pakai office 64
bit. *** kalau pakai office 64 bit, biasanya
pakai aplikasi lain yang 32 bit untuk mengambil data dari
dbf file tersebut, setelah itu baru di export ke
Excel.

Regards,Kid




On Tue, Apr 2,
2019 at 4:00 PM It Dpm it_dpm@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>
wrote:















 










setelah sy tanyakan itu hasil generate dari
program yg dibuat menggunakan bahasa foxpro, cuma sekarang
vendornya sudah tidak ada lagi (source code programnya juga
tidak ada) jadi hasil generate file dbf nya seperti. mohon
bantuannya mungkin ada yg punya solusi, saya butuh datanya
bisa masuk ke dalam excel tanpa harus copy 1 per 1 per kolom
dari programnya..terima kasih






Pada Selasa, 2 April 2019 08.03.44
GMT+7, 'Mr. Kid' mr.nmkid@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>
menulis:






 









Coba ditanyakan ke pihak pemberi file.

Sent from my smart enough
phone
On Apr 1, 2019, at 21:33, It Dpm it_dpm@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>
wrote:
















 






kalau
untuk file dbf yg saya lampirkan itu jenisnya dbf yg apa
ya?
































































#yiv8785573265 #yiv8785573265 --
#yiv8785573265ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv8785573265 #yiv8785573265ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv8785573265 #yiv8785573265ygrp-mkp #yiv8785573265hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv8785573265 #yiv8785573265ygrp-mkp #yiv8785573265ads {
margin-bottom:10px;}

#yiv8785573265 #yiv8785573265ygrp-mkp .yiv8785573265ad {
padding:0 0;}

#yiv8785573265 #yiv8785573265ygrp-mkp .yiv8785573265ad p {
margin:0;}

#yiv8785573265 #yiv8785573265ygrp-mkp .yiv8785573265ad a {
color:#0000ff;text-decoration:none;}
#yiv8785573265 #yiv8785573265ygrp-sponsor
#yiv8785573265ygrp-lc {
font-family:Arial;}

#yiv8785573265 #yiv8785573265ygrp-sponsor
#yiv8785573265ygrp-lc #yiv8785573265hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv8785573265 #yiv8785573265ygrp-sponsor
#yiv8785573265ygrp-lc .yiv8785573265ad {
margin-bottom:10px;padding:0 0;}

#yiv8785573265 #yiv8785573265actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv8785573265 #yiv8785573265activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv8785573265 #yiv8785573265activity span {
font-weight:700;}

#yiv8785573265 #yiv8785573265activity span:first-child {
text-transform:uppercase;}

#yiv8785573265 #yiv8785573265activity span a {
color:#5085b6;text-decoration:none;}

#yiv8785573265 #yiv8785573265activity span span {
color:#ff7900;}

#yiv8785573265 #yiv8785573265activity span
.yiv8785573265underline {
text-decoration:underline;}

#yiv8785573265 .yiv8785573265attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv8785573265 .yiv8785573265attach div a {
text-decoration:none;}

#yiv8785573265 .yiv8785573265attach img {
border:none;padding-right:5px;}

#yiv8785573265 .yiv8785573265attach label {
display:block;margin-bottom:5px;}

#yiv8785573265 .yiv8785573265attach label a {
text-decoration:none;}

#yiv8785573265 blockquote {
margin:0 0 0 4px;}

#yiv8785573265 .yiv8785573265bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv8785573265 .yiv8785573265bold a {
text-decoration:none;}

#yiv8785573265 dd..yiv8785573265last p a {
font-family:Verdana;font-weight:700;}

#yiv8785573265 dd.yiv8785573265last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv8785573265 dd.yiv8785573265last p
span.yiv8785573265yshortcuts {
margin-right:0;}

#yiv8785573265 div.yiv8785573265attach-table div div a {
text-decoration:none;}

#yiv8785573265 div.yiv8785573265attach-table {
width:400px;}

#yiv8785573265 div.yiv8785573265file-title a, #yiv8785573265
div.yiv8785573265file-title a:active, #yiv8785573265
div.yiv8785573265file-title a:hover, #yiv8785573265
div.yiv8785573265file-title a:visited {
text-decoration:none;}

#yiv8785573265 div.yiv8785573265photo-title a,
#yiv8785573265 div.yiv8785573265photo-title a:active,
#yiv8785573265 div.yiv8785573265photo-title a:hover,
#yiv8785573265 div.yiv8785573265photo-title a:visited {
text-decoration:none;}

#yiv8785573265 div#yiv8785573265ygrp-mlmsg
#yiv8785573265ygrp-msg p a span.yiv8785573265yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv8785573265 .yiv8785573265green {
color:#628c2a;}

#yiv8785573265 .yiv8785573265MsoNormal {
margin:0 0 0 0;}

#yiv8785573265 o {
font-size:0;}

#yiv8785573265 #yiv8785573265photos div {
float:left;width:72px;}

#yiv8785573265 #yiv8785573265photos div div {
border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}

#yiv8785573265 #yiv8785573265photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv8785573265 #yiv8785573265reco-category {
font-size:77%;}

#yiv8785573265 #yiv8785573265reco-desc {
font-size:77%;}

#yiv8785573265 .yiv8785573265replbq {
margin:4px;}

#yiv8785573265 #yiv8785573265ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv8785573265 #yiv8785573265ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv8785573265 #yiv8785573265ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv8785573265 #yiv8785573265ygrp-mlmsg select,
#yiv8785573265 input, #yiv8785573265 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv8785573265 #yiv8785573265ygrp-mlmsg pre, #yiv8785573265
code {
font:115% monospace;}

#yiv8785573265 #yiv8785573265ygrp-mlmsg * {
line-height:1.22em;}

#yiv8785573265 #yiv8785573265ygrp-mlmsg #yiv8785573265logo {
padding-bottom:10px;}


#yiv8785573265 #yiv8785573265ygrp-msg p a {
font-family:Verdana;}

#yiv8785573265 #yiv8785573265ygrp-msg
p#yiv8785573265attach-count span {
color:#1E66AE;font-weight:700;}

#yiv8785573265 #yiv8785573265ygrp-reco
#yiv8785573265reco-head {
color:#ff7900;font-weight:700;}

#yiv8785573265 #yiv8785573265ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv8785573265 #yiv8785573265ygrp-sponsor #yiv8785573265ov
li a {
font-size:130%;text-decoration:none;}

#yiv8785573265 #yiv8785573265ygrp-sponsor #yiv8785573265ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv8785573265 #yiv8785573265ygrp-sponsor #yiv8785573265ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv8785573265 #yiv8785573265ygrp-text {
font-family:Georgia;}

#yiv8785573265 #yiv8785573265ygrp-text p {
margin:0 0 1em 0;}

#yiv8785573265 #yiv8785573265ygrp-text tt {
font-size:120%;}

#yiv8785573265 #yiv8785573265ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv8785573265

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2a

Re: mencari start date & Finish [1 Attachment]

Mon Apr 22, 2019 6:17 pm (PDT) . Posted by:

"Iman Darusman" idz.iman

Dear Master,
mohon bantuannya (sundul)
salamIman
Pada Selasa, 16 April 2019 17.33.52 WIB, idz.iman@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Dear Master.

mohon bantuannya rumus untuk mengetahui start date & finish pada file terlampir.

salam

Iman
#yiv8052531472 #yiv8052531472 -- #yiv8052531472ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8052531472 #yiv8052531472ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8052531472 #yiv8052531472ygrp-mkp #yiv8052531472hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8052531472 #yiv8052531472ygrp-mkp #yiv8052531472ads {margin-bottom:10px;}#yiv8052531472 #yiv8052531472ygrp-mkp .yiv8052531472ad {padding:0 0;}#yiv8052531472 #yiv8052531472ygrp-mkp .yiv8052531472ad p {margin:0;}#yiv8052531472 #yiv8052531472ygrp-mkp .yiv8052531472ad a {color:#0000ff;text-decoration:none;}#yiv8052531472 #yiv8052531472ygrp-sponsor #yiv8052531472ygrp-lc {font-family:Arial;}#yiv8052531472 #yiv8052531472ygrp-sponsor #yiv8052531472ygrp-lc #yiv8052531472hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8052531472 #yiv8052531472ygrp-sponsor #yiv8052531472ygrp-lc .yiv8052531472ad {margin-bottom:10px;padding:0 0;}#yiv8052531472 #yiv8052531472actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8052531472 #yiv8052531472activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8052531472 #yiv8052531472activity span {font-weight:700;}#yiv8052531472 #yiv8052531472activity span:first-child {text-transform:uppercase;}#yiv8052531472 #yiv8052531472activity span a {color:#5085b6;text-decoration:none;}#yiv8052531472 #yiv8052531472activity span span {color:#ff7900;}#yiv8052531472 #yiv8052531472activity span .yiv8052531472underline {text-decoration:underline;}#yiv8052531472 .yiv8052531472attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8052531472 .yiv8052531472attach div a {text-decoration:none;}#yiv8052531472 .yiv8052531472attach img {border:none;padding-right:5px;}#yiv8052531472 .yiv8052531472attach label {display:block;margin-bottom:5px;}#yiv8052531472 .yiv8052531472attach label a {text-decoration:none;}#yiv8052531472 blockquote {margin:0 0 0 4px;}#yiv8052531472 .yiv8052531472bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8052531472 .yiv8052531472bold a {text-decoration:none;}#yiv8052531472 dd.yiv8052531472last p a {font-family:Verdana;font-weight:700;}#yiv8052531472 dd.yiv8052531472last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8052531472 dd.yiv8052531472last p span.yiv8052531472yshortcuts {margin-right:0;}#yiv8052531472 div.yiv8052531472attach-table div div a {text-decoration:none;}#yiv8052531472 div.yiv8052531472attach-table {width:400px;}#yiv8052531472 div.yiv8052531472file-title a, #yiv8052531472 div.yiv8052531472file-title a:active, #yiv8052531472 div.yiv8052531472file-title a:hover, #yiv8052531472 div.yiv8052531472file-title a:visited {text-decoration:none;}#yiv8052531472 div.yiv8052531472photo-title a, #yiv8052531472 div.yiv8052531472photo-title a:active, #yiv8052531472 div.yiv8052531472photo-title a:hover, #yiv8052531472 div.yiv8052531472photo-title a:visited {text-decoration:none;}#yiv8052531472 div#yiv8052531472ygrp-mlmsg #yiv8052531472ygrp-msg p a span.yiv8052531472yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8052531472 .yiv8052531472green {color:#628c2a;}#yiv8052531472 .yiv8052531472MsoNormal {margin:0 0 0 0;}#yiv8052531472 o {font-size:0;}#yiv8052531472 #yiv8052531472photos div {float:left;width:72px;}#yiv8052531472 #yiv8052531472photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8052531472 #yiv8052531472photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8052531472 #yiv8052531472reco-category {font-size:77%;}#yiv8052531472 #yiv8052531472reco-desc {font-size:77%;}#yiv8052531472 .yiv8052531472replbq {margin:4px;}#yiv8052531472 #yiv8052531472ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8052531472 #yiv8052531472ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8052531472 #yiv8052531472ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8052531472 #yiv8052531472ygrp-mlmsg select, #yiv8052531472 input, #yiv8052531472 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8052531472 #yiv8052531472ygrp-mlmsg pre, #yiv8052531472 code {font:115% monospace;}#yiv8052531472 #yiv8052531472ygrp-mlmsg * {line-height:1..22em;}#yiv8052531472 #yiv8052531472ygrp-mlmsg #yiv8052531472logo {padding-bottom:10px;}#yiv8052531472 #yiv8052531472ygrp-msg p a {font-family:Verdana;}#yiv8052531472 #yiv8052531472ygrp-msg p#yiv8052531472attach-count span {color:#1E66AE;font-weight:700;}#yiv8052531472 #yiv8052531472ygrp-reco #yiv8052531472reco-head {color:#ff7900;font-weight:700;}#yiv8052531472 #yiv8052531472ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8052531472 #yiv8052531472ygrp-sponsor #yiv8052531472ov li a {font-size:130%;text-decoration:none;}#yiv8052531472 #yiv8052531472ygrp-sponsor #yiv8052531472ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8052531472 #yiv8052531472ygrp-sponsor #yiv8052531472ov ul {margin:0;padding:0 0 0 8px;}#yiv8052531472 #yiv8052531472ygrp-text {font-family:Georgia;}#yiv8052531472 #yiv8052531472ygrp-text p {margin:0 0 1em 0;}#yiv8052531472 #yiv8052531472ygrp-text tt {font-size:120%;}#yiv8052531472 #yiv8052531472ygrp-vital ul li:last-child {border-right:none !important;}#yiv8052531472

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use