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
lecture
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
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
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:
visit this site :
http://www.daniweb.com/forums/thread119197.html
--- On Tue, 8/3/10, Marc Guay marc.g...@gmail.com wrote:
From: Marc Guay marc.g...@gmail.com
Subject: Re: from excel to the mySQL
To: HaidarPesebe haidarpes...@gmail.com
Cc: MySQL Lists mysql@lists.mysql.com
Date
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
To:
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
+0100
Subject: Re: 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
management