file dengan extension dbf juga bisa di buka dengan Ms Acces -------------------------------------------- Pada Rab, 3/4/19, hendrik karnadi hendrikkarn...@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.nm...@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_...@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.nm...@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_...@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