A'Koerdays Blog

29 Maret 2010

IMPORT FILE EXCEL KE FOXPRO

Filed under: 1 — akoerday @ 10:05 am
Tags:

IMPORT FILE EXCEL KE FOXPRO
Rubah NO_ASET, kuantitas,rph_sat,dan rph_aset ke general (tanpa decimal)
SaveFile Excel ke TabDelimeted.Txt
Simpan file di mydocuments\visual foxpro project
Buka New foxpro
Tool s  Wizard import
Text file
Klik locate
Cari nama file *.txt
Next
Pilih create my table as stand-alone free table
Next
Begin imprt at row isi dengan 2
Next
Next
Baru sesuaikan header name, type, width, dan decimal seperti dibawah ini
(thn_ang c(4), periode c(2), kd_lokasi c(20), no_sppa c(12), kd_brg c(10), no_aset n(20) (4),
tgl_perlh D(8), tercatat c(1), kondisi c(1), tgl_buku D(8), jns_trn c(3), dsr_hrg c(1), kd_data c(1),
flag_sap c(1), kuantitas n(20) (4), rph_sat n(20) (4), rph_aset n(20) (4), flag_kor c(1),
keterangan c(50), merk_type c(50), asal_perlh c(50), no_bukti c(50), no_dsr_mts c(50),
tgl_dsr_mt D(8), flag_ttp c(1), flag_krm c(1), kdblu c(1), setatus c(2), noreg c(12))

next
next
finish
view  browse
delete record pertama (table  delete record delete)  table  remove deleted records
view  browse
keluar foxpro
ganti nama file t_mu0900finaltukimport .dbfmenjadi t_mu0900.dbf
gabung t_mu0900.dbf dengan backup bmnkpb

Tinggalkan sebuah Komentar »

Belum ada komentar.

RSS feed for comments on this post. TrackBack URI

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

Blog di WordPress.com.

%d blogger menyukai ini: