Sekedar menambahkan....
coba pake MySQL migration toolkit dari dari MySQL AB
====================================================
The MySQL Migration Toolkit is a graphical tool
provided by MySQL AB for migrating schema and data
from various relational database systems to MySQL.
MySQL Migration Toolkit is designed to work with MySQL
versions 4.1 and higher.
................................................
The following are some of the key features of the
MySQL Migration Toolkit:
*
The MySQL Migration Toolkit supports a variety
of source database systems, including the following:
o
Oracle
o
Microsoft SQL Server
o
Microsoft Access
*
The MySQL Migration Toolkit is fully
customizable through its Java runtime interface.
Advanced users can use Java to perform custom data and
schema transformations.
*
The MySQL Migration Toolkit supports agent-based
data migrations, with the MySQL Migration Toolkit
residing on a separate machine than the source and
target database servers, through the use of a special
migration agent. The agent-based data migration
improves migration performance by allowing data to be
transferred directly from the source machine to the
target machine without being router through the MySQL
Migration Toolkit.
--- Lastiko Wibisono <[EMAIL PROTECTED]>
wrote:
> 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
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
___________________________________________________________
How much free photo storage do you get? Store your holiday
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
