pake bcp aja, tapi kalau bcp itu runningnya dari command promt, tapi pasti ada cara untuk menjalankan bcp itu dari sql langsung, ada beberapa procedure yang udah built in nya sql server, tapi masih belum ketemu.. contoh: database name : SALES server name : SERVER username : sa password : pass table name : customer
bcp "select * from SALES..customer" queryout "C:\customer.xls" -C -S SERVER -U sa -P pass ----- Original Message ---- From: Evi Damayanti <[EMAIL PROTECTED]> To: VB Program <[email protected]> Sent: Thursday, January 25, 2007 10:02:48 AM Subject: [indoprog-vb] Cara Bikin Import/Eksport Database SQl langsung dari software Hallooo..... ...... Mau tanya... Ada yang tau gak gmn caranya klo kita mau bikin software untuk import/eksport database antara sql server 2000 atau antara Excel dengan SQl Server 2000 Tolong yah....buat siapa ajah yang tau...butuh cepet banget niyh.....puucciiiii iiiiiiiingngng dehhhhhhhh.. ..... dan terimakasih sebelumnya.. . Evi ____________ _________ _________ _________ _________ _________ _ Have a burning question? Go to www.Answers. yahoo.com and get answers from real people who know. ____________________________________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097 [Non-text portions of this message have been removed]
