// From: Chase [mailto:[EMAIL PROTECTED]]
// Sent: Sunday, 30 June 2002 5:57 AM
// To: [EMAIL PROTECTED]
// Subject: Re: [PHP-DB] Excel to MySQL??
//
//
// My webhost is running phpMyAdmin v2.2.2 and it is giving me
// errors when
// I try to load the file. Are there any certain characters
//
My webhost is running phpMyAdmin v2.2.2 and it is giving me errors when
I try to load the file. Are there any certain characters that cannot be
in the file? (ie. "$")
Chase
Peter Lovatt wrote:
> Hi
>
> from Excel export to csv
>
> use phpMyAdmin to load it into mysql (recent versions of p
At 15:21 -0600 6/29/02, Chase wrote:
>Does anyone know of a way that I can export an Excel spreadsheet to
>a file that I can import to MySQL? I found a program that will do
>this for Access, but I would rather leave Access out of this if
>possible. Thanks!!
>
>Chase
Does it have to be written
June 29, 2002 4:49 PM
> To: Chase; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Excel to MySQL??
>
>
> Hi
>
> from Excel export to csv
>
> use phpMyAdmin to load it into mysql (recent versions of phpMyAdmin has an
&
Hi
from Excel export to csv
use phpMyAdmin to load it into mysql (recent versions of phpMyAdmin has an
Excel import function)
HTH
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.s
> Is it possible to migrate data into a table in MS Excel to MySQL?
Export to csv from excel and the mysqlimport command is your friend
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
I've also had great results simply saving my Excel in a *.csv format, then
importing it directly into mySQL.
-Original Message-
From: dmalcolm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 4:04 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Excel to Mysql
Gabriel
Gabriel Adame wrote:
> Hi,
>
> ¿ Please, someone have an excel macro to export data to mysql ?
>
> Thanks
>
> Gaby
> _
>
> ¿ Tu mama piensa que eres muy inteligente ?
>Desengañate jugando ...
> http://www.atrivia.com
> __
Gaby,
You could save the excel as a text file and then load the file into MySQL
Wayne
On Fri, 16 Feb 2001 11:45, Gabriel Adame wrote:
> > Hi,
>
> ¿ Please, someone have an excel macro to export data to mysql ?
>
> Thanks
>
> Gaby
> _
>
> ¿ Tu mama piensa que
