Re: ]] XL-mania [[ Link excel ke MySQL

kalo di excel 2007, klik *Data*--> *From Other Sources*--> di *Data
Connection Wizard* ketik server name nya (*IP address
server*)-->*Next*-->*Select database and table* (di combo box pilih nama
databasenya dalam hal ini--> di bawahnya pilih nama tabel yang akan di
ambil--> next-> Finish-->OK

Kalo mau di update tinggal di refresh aja coz kalo data SQL nya berubah
data tampilan di excelnya juga ikut berubah.

NB: tapi harus konek dulu ke server sebelum melakukan step di atas
caranya buka explorer--> di address bar ketik \\IP address server contoh
\\192.168.1.1 trus masukan user name nad password server trus OK

TQ

chusk soepono wrote:
>
> Dear Excel Expert,
> Ada yang punya pengalaman me-link excel ke data base MySQL menggunakan
> ODBC /ADO?, Mohon dishare trick macro nya dong?
>
> Misalnya diinginkan membuat sheet di excel ngelink dengan:
> database : DBmySQL
> Tabel : tblmySQL
> Field :FieldmySQL1,FieldmySQL2,FieldmySQL3
>
> Ingin ditulis ke worksheet :
> Sheet :sheet1
> Kolom : KolomA,KolomB,KolomC
>
> catatan:
> Jumlah record sifatnya dinamis -->bila ditambah/didelete di MySQL bisa
> langsung update di Excelnya.
> MySQL servernya ada dikomputer lain dengan IP : 192.168.1.5
> IP Excel nya : 192.168.1.6
> user mySQL : usersql
> Password : passwordmysql
>
> Mohon dibantu step-stepnya ya ...
>
> Terima kasih,
> Adi
>
> Lebih aman saat online. Upgrade ke Internet Explorer 8 baru dan lebih
> cepat yang dioptimalkan untuk Yahoo! agar Anda merasa lebih aman.
> Gratis. Dapatkan IE8 di sini!
> http://downloads.yahoo.com/id/internetexplorer/
> <http://downloads.yahoo.com/id/internetexplorer/>
>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4749 (20100106) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4749 (20100106) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

------------------------------------

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Resolusi 2010 XL-mania: terbitkan buku lagi... hehehe... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/XL-mania/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/XL-mania/join
(Yahoo! ID required)

<*> To change settings via email:
XL-mania-digest@yahoogroups.com
XL-mania-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
XL-mania-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/