Import CSV Data ke Tabel DB

Sekali lagi pakai saja LIBRE CALC dan SQLYog Community Free Edition

Setelah data sheet di save as ke format CSV di libre calc,

import hasil CSV ke SQLYog, dengan cara :

klik kanan salah satu tabel di DB, pilih import – import CSV Data using LOAD LOCAL,

klik tombol change – setting konfigurasi sesuai gambar…

*) bisa klik tombol fill excel friendly values, sisanya sesuaikan centangnya

import_csv

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s