Thanks for your information, we have tried it and solve my problems.
Thanks.
- Original Message -
From: Miguel Vaz
To: HaidarPesebe
Cc: MySQL Lists
Sent: Wednesday, August 04, 2010 1:40 AM
Subject: Re: from excel to the mySQL
Hi,
Ive always used navicat for mysql
Hi!
Data Wizard for MySQL allows you to import data from Excel (as well as
from CSV, DBF, XML and text files) in a few mouse clicks. The app also
provides a flexible task scheduler.
http://www.sqlmaestro.com/products/mysql/datawizard/
- Original Message -
From: "HaidarPesebe"
To: "MySQL
Thanks for your information, we are sorry about this.
- Original Message -
From: Martin Gainty
To: pagong...@gmail.com ; haidarpes...@gmail.com
Cc: mysql@lists.mysql.com
Sent: Wednesday, August 04, 2010 6:20 AM
Subject: RE: from excel to the mySQL
Vaz
please
: from excel to the mySQL
> From: pagong...@gmail.com
> To: haidarpes...@gmail.com
> CC: mysql@lists.mysql.com
>
> Hi,
>
> Ive always used navicat for mysql and it does wonders for import/export
> (wether it be from excel or any other file type) and also general database
&g
Hi,
Ive always used navicat for mysql and it does wonders for import/export
(wether it be from excel or any other file type) and also general database
management. Actually, too many features to list here, check the website:
http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html
hi HaidarPesebe,
one way to do this is :
1. save the excel to xxx.csv
2. then use the mysql SQL statement "LOAD DATA INFILE"
for example :
LOAD DATA INFILE 'c:\\test\\xxx.csv'
INTO TABLE tbl_name
FIELDS TERMINATED BY ','
best regards
liuyann
> From: haidarpes...@gmail.com
>
visit this site :
http://www.daniweb.com/forums/thread119197.html
--- On Tue, 8/3/10, Marc Guay wrote:
From: Marc Guay
Subject: Re: from excel to the mySQL
To: "HaidarPesebe"
Cc: "MySQL Lists"
Date: Tuesday, August 3, 2010, 7:34 AM
> I'm needs a way
> I'm needs a way to upload data from excel to the mySQL database. Dear all, I
> need help is how to upload data from excel columns and load into mysql
> database using php?
http://www.sqldbu.com/eng/sections/tips/mysqlimport.html
--
MySQL General Mailing List
For list archives: http://lists.m
