Iya, kalau filenya kecil (record < 65535). Kalau banyak/besar, ya harus dari native program yg bisa baca DBF-nya ke CSV. Aku dulu pernah buat transfer data sales di DBF yang lumayan gede, pindahinnya ya pakai program kecil dulu pakai FoxPro ke CSV, baru diangkat ke Oracle. Cuma format date, numeric, dan string delimiter (kasus adanya ' & ", karakter khusus) harus diperhatikan. Ini suka bikin error kalau gak hati-2x. Kalau pakai memo lebih repot lagi.
Rgds Ervin L --- In [email protected], "Lia" <[EMAIL PROTECTED]> wrote: > Kalo saya sih biasanya, file dbf nya saya buka dulu pake excel, trus saya > simpan dalam bentuk file .csv baru ditransfer dengan SQLLDR. > > ----- Original Message ----- > From: "Ervin Listyawan" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Thursday, August 25, 2005 2:05 AM > Subject: [indo-oracle] Re: Export File DBF > > > Mbak Lia, > > Nggak salah nih, SQL LOADER kan cuma bisa baca file text/ASCII, > ataupun kalau dipaksa baca file binary, mesti jelas aturannya. > Lha ini yg ditanya Pak Handoko file DBF, bagaimana caranya? Kalau > dulu aku pernah pakai ODBC, cuma krn lambat baru aku transfer ke text- > file dulu dari database asal. > > Share dong caranya kalau memang bisa baca DBF pakai SQLLOADER. > > Regards, > > Ervin L > > > --- In [email protected], "Lia" <[EMAIL PROTECTED]> wrote: > > Hai Handoko, > > > > Biasanya sih saya pakai SQL LOADER, perintahnya SQLLDR di command > prompt. > > Coba deh cari di google.. > > > > > > ----- Original Message ----- > > From: "Handoko" <[EMAIL PROTECTED]> > > To: <[email protected]> > > Sent: Tuesday, August 23, 2005 2:45 AM > > Subject: [indo-oracle] Export File DBF > > > > > > > Dear Oracle Mania.. > > > > > > Gimana caranya import file DBF ke oracle..? > > > ada yang bisa bantu..? ato kasih keywordnya u/ searching. > > > > > > terima kasih atas respon rekan-rekan semua. > > > > > > Handoko ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
