Dari Microsoft Excel coba save file as CVS File, trus baru pake yang insert data from a textfile. Masing-masing baris akan menjadi record-nya dengan pembatas antar kolomnya (field dari tabel) suatu karakter misalnya ;.
Quoting Agoes <[EMAIL PROTECTED]>: > Dear all, mau nanya nih > kalo kita mau ekspor file excel ke mysql gimana caranya yah? > > saya dah coba "insert data from a textfile into table" > tapi hasilnya cuma satu baris dan itu error pula isinya. > > ada yang bisa bantu gak? > > Thanks > Agoes > > Send instant messages to your online friends http://asia.messenger.yahoo.com > > > > > --- > Website: http://toekangweb.or.id/ > Arsip milis : http://groups.yahoo.com/group/toekangweb/messages > > Yahoo! Groups Links > > > > > > > -- Ayo maju pengusaha muda ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/AZzolB/TM --------------------------------------------------------------------~-> --- Website: http://toekangweb.or.id/ Arsip milis : http://groups.yahoo.com/group/toekangweb/messages Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/toekangweb/ <*> 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/
