Solution lain: Anda bisa coba pakai MS. access, 1. Import atau buat link di access ke MS. excel file. 2. Buat link ke table di MySQL pakai ODBC. 3. Buat query untuk insert dari table (excel) ke table di MySQL.
Semoga membantu. santosa --- Djoko <[EMAIL PROTECTED]> wrote: > Seniorz... > Minta saran/tips/contoh script dari seniorz... aku > punya data Excel yg > mo dimasukkan ke MySQL. Record di Excel-nya sudah 4 > digit banyaknya jd > kayaknya gak mungkin ditulis satu persatu. > > di Excelnya kolomnya spt ini: > NoID Apr03 Mar03 Feb03 Jan03 > 100 4 2 7 > 5 > 101 3 5 0 > 1 > > Data lama tsb pingin pingin di konvert ke MySQL > dengan struktur tabel sbb: > NoID Bulan Tahun Jml > 100 1 2003 5 > 100 2 2003 7 > 100 3 2003 2 > 100 4 2003 4 > 101 1 2003 5 > 101 2 2003 7 > 101 3 2003 2 > 101 4 2003 4 > > Bagaimana yg paling tepat.. paling sedikit > kesalahan... paling > efisien...???? > > JK > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahanaprogrammer Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-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/
