try this : msql = "INSERT INTO GABUNG(KODE,NAMA) SELECT KODE,NAMA FROM PARTS"
----- Original Message ----- From: "garudamas" <[EMAIL PROTECTED]> > saya punya table gabung dan parts yang dari acces saya eksport ke sql server > 2000 > gabung (kode nvarchar 15, nama nvarchar 15, awalq float 8) dan > parts(kode nvarchar 15, nama nvarchar 15, awalq float 8) > > dan saya coba sedikit fields aja > msql = "INSERT INTO GABUNG SELECT KODE,NAMA FROM PARTS" > > munculnya insert error : column name or number of supplied values does not > match table definition. kira2 solusinya gimana ya > ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/zCsqlB/TM --------------------------------------------------------------------~-> Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> 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/
