cara paling mudah dan cepat lewat dts. caranya: - open enterprise manager - select database tujuan / diinginkan - klik kanan, pilih all task - pilih import - klik next - pada selection datasource , pilih mcft (microsoft access) - klik file name untuk memilih file - setelah file dipilih, klik next - pilih servername tujuan, username , password dan database tujuan -pilih copy table atau copy object - klik next - modif sesuai tujuan untuk transformasi table - klik next - klik next
table access anda akan diimport ke databse mssql semoga bermanfaat ----- Original Message ----- From: ar.ruh.nov To: [email protected] Sent: Wednesday, July 19, 2006 10:11 AM Subject: [ITCENTER] Convert Acces ke SQL Dear teman-teman Ada yang punya trik, tutorial or apapun untuk convert data dari access (*.mdb) ke Sql server 2000 Thanks. sebelumnya salam arief [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> 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/
