from excel to the mySQL

am 03.08.2010 11:23:22 von HaidarPesebe

------=_NextPart_000_004B_01CB3328.31085850
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear All,
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?
Thanks
HaidarPesebe
------=_NextPart_000_004B_01CB3328.31085850--

Re: from excel to the mySQL

am 03.08.2010 15:34:04 von Marc Guay

> 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.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: from excel to the mySQL

am 03.08.2010 15:49:52 von sam rumaizan

--0-1773379057-1280843392=:42719
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

=A0
visit this site :
=A0
http://www.daniweb.com/forums/thread119197.html

=A0

--- 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 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

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Dsamcalc@yahoo.c=
om

=0A
--0-1773379057-1280843392=:42719--

RE: from excel to the mySQL

am 03.08.2010 16:16:05 von LIU YAN

--_df1f492f-84c7-4d4c-9292-728bb5b7a7d3_
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit

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: haidarpesebe@gmail.com
> To: mysql@lists.mysql.com
> Subject: from excel to the mySQL
> Date: Tue, 3 Aug 2010 16:23:22 +0700
>
> Dear All,
> 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?
> Thanks
> HaidarPesebe

--_df1f492f-84c7-4d4c-9292-728bb5b7a7d3_--

Re: from excel to the mySQL

am 03.08.2010 20:40:58 von Miguel Vaz

--00032555ac1a7a69ef048cefa85a
Content-Type: text/plain; charset=ISO-8859-1

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_overv iew.html

Pag

On Tue, Aug 3, 2010 at 10:23 AM, HaidarPesebe wrote:

> Dear All,
> 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?
> Thanks
> HaidarPesebe

--00032555ac1a7a69ef048cefa85a--

RE: from excel to the mySQL

am 04.08.2010 01:20:12 von Martin Gainty

--_ad6d6de3-e89a-4da2-a861-26393d37dbb1_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Vaz
=20

please do not insert bogus display names into the email display name (such =
as Vaz when your real name is haidarpesebe)
most responsible mail-admins wont tolerate this type of spoofing or any typ=
e of email spoofing
and if your name is VAZ use the email address created for VAZ instead of ha=
idarpesebe

Martin=20
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
=20

> Date: Tue=2C 3 Aug 2010 19:40:58 +0100
> Subject: Re: from excel to the mySQL
> From: pagongski@gmail.com
> To: haidarpesebe@gmail.com
> CC: mysql@lists.mysql.com
>=20
> Hi=2C
>=20
> 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 databas=
e
> management. Actually=2C too many features to list here=2C check the websi=
te:
>=20
> http://www.navicat.com/en/products/navicat_mysql/mysql_overv iew.html
>=20
>=20
>=20
>=20
> Pag
>=20
>=20
> On Tue=2C Aug 3=2C 2010 at 10:23 AM=2C HaidarPesebe om>wrote:
>=20
> > Dear All=2C
> > I'm needs a way to upload data from excel to the mySQL database. Dear a=
ll=2C
> > I need help is how to upload data from excel columns and load into mysq=
l
> > database using php?
> > Thanks
> > HaidarPesebe
=

--_ad6d6de3-e89a-4da2-a861-26393d37dbb1_--

Re: from excel to the mySQL

am 04.08.2010 10:08:42 von HaidarPesebe

------=_NextPart_000_0081_01CB33E6.ED1C7170
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks for your information, we are sorry about this.

----- Original Message -----=20
From: Martin Gainty=20
To: pagongski@gmail.com ; haidarpesebe@gmail.com=20
Cc: mysql@lists.mysql.com=20
Sent: Wednesday, August 04, 2010 6:20 AM
Subject: RE: from excel to the mySQL

Vaz
=20

please do not insert bogus display names into the email display name =
(such as Vaz when your real name is haidarpesebe)
most responsible mail-admins wont tolerate this type of spoofing or =
any type of email spoofing
and if your name is VAZ use the email address created for VAZ instead =
of haidarpesebe

Martin=20
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene =
Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede =
unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. =
Diese Nachricht dient lediglich dem Austausch von Informationen und =
entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten =
Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt =
uebernehmen.

=20
> Date: Tue, 3 Aug 2010 19:40:58 +0100
> Subject: Re: from excel to the mySQL
> From: pagongski@gmail.com
> To: haidarpesebe@gmail.com
> CC: mysql@lists.mysql.com
>=20
> Hi,
>=20
> 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:
>=20
> http://www.navicat.com/en/products/navicat_mysql/mysql_overv iew.html
>=20
>=20
>=20
>=20
> Pag
>=20
>=20
> On Tue, Aug 3, 2010 at 10:23 AM, HaidarPesebe =
wrote:
>=20
> > Dear All,
> > 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?
> > Thanks
> > HaidarPesebe

__________ Information from ESET Smart Security, version of virus =
signature database 5338 (20100803) __________

The message was checked by ESET Smart Security.

http://www.eset.com

------=_NextPart_000_0081_01CB33E6.ED1C7170--

Re: from excel to the mySQL

am 04.08.2010 10:10:06 von SQL Maestro Team

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 Lists"
Sent: Tuesday, August 03, 2010 3:23 PM
Subject: from excel to the mySQL

> Dear All,
> 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?
> Thanks
> HaidarPesebe

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: from excel to the mySQL

am 04.08.2010 10:16:42 von HaidarPesebe

------=_NextPart_000_008A_01CB33E8.0B63CBF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks for your information, we have tried it and solve my problems.
Thanks.
----- Original Message -----=20
From: Miguel Vaz=20
To: HaidarPesebe=20
Cc: MySQL Lists=20
Sent: Wednesday, August 04, 2010 1:40 AM
Subject: Re: from excel to the mySQL

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_overv iew.html

Pag

On Tue, Aug 3, 2010 at 10:23 AM, HaidarPesebe =
wrote:

Dear All,
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?
Thanks
HaidarPesebe

------=_NextPart_000_008A_01CB33E8.0B63CBF0--