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 Excel import function) HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: Chase [mailto:[EMAIL PROTECTED]] > Sent: 29 June 2002 22:22 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Excel to MySQL?? > > > 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 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Excel to MySQL??
Or if you don't use phpMyAdmin you can use LOAD DATA INFILE once you have saved the Excel doc as a .csv file: http://www.mysql.com/doc/L/O/LOAD_DATA.html Jen Swofford [EMAIL PROTECTED] > -Original Message- > From: Peter Lovatt [mailto:[EMAIL PROTECTED]] > Sent: Saturday, 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 > Excel import function) > > HTH > > Peter > > --- > Excellence in internet and open source software > --- > Sunmaia > www.sunmaia.net > [EMAIL PROTECTED] > tel. 0121-242-1473 > --- > > > -Original Message- > > From: Chase [mailto:[EMAIL PROTECTED]] > > Sent: 29 June 2002 22:22 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Excel to MySQL?? > > > > > > 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 > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Excel to MySQL??
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 in PHP? :-)
#! /usr/bin/perl -w
# from_excel.pl - read Excel spreadsheet, write tab-delimited,
# linefeed-terminated output to the standard output.
use strict;
use Spreadsheet::ParseExcel::Simple;
@ARGV or die "Usage: $0 excel-file\n";
my $xls = Spreadsheet::ParseExcel::Simple->read ($ARGV[0]);
foreach my $sheet ($xls->sheets ())
{
while ($sheet->has_data ())
{
my @data = $sheet->next_row ();
print join ("\t", @data) . "\n";
}
}
exit (0);
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 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 phpMyAdmin has an > Excel import function) > > HTH > > Peter > > --- > Excellence in internet and open source software > --- > Sunmaia > www.sunmaia.net > [EMAIL PROTECTED] > tel. 0121-242-1473 > --- > > >>-Original Message- >>From: Chase [mailto:[EMAIL PROTECTED]] >>Sent: 29 June 2002 22:22 >>To: [EMAIL PROTECTED] >>Subject: [PHP-DB] Excel to MySQL?? >> >> >>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 >> >> >>-- >>PHP Database Mailing List (http://www.php.net/) >>To unsubscribe, visit: http://www.php.net/unsub.php >> >> > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Excel to MySQL??
make sure there are no "#" chars in there, unless you have commented lines out (as below) # commented line in phpMyAdmin that is a comment, and the way it reads, if there's a # on a line, it comments from there onwards (from memory) HTH Beau // -Original Message- // 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 // 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 // phpMyAdmin has an // > Excel import function) // > // > HTH // > // > Peter // > // > --- // > Excellence in internet and open source software // > --- // > Sunmaia // > www.sunmaia.net // > [EMAIL PROTECTED] // > tel. 0121-242-1473 // > --- // > // > // >>-Original Message- // >>From: Chase [mailto:[EMAIL PROTECTED]] // >>Sent: 29 June 2002 22:22 // >>To: [EMAIL PROTECTED] // >>Subject: [PHP-DB] Excel to MySQL?? // >> // >> // >>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 // >> // >> // >>-- // >>PHP Database Mailing List (http://www.php.net/) // >>To unsubscribe, visit: http://www.php.net/unsub.php // >> // >> // > // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, visit: http://www.php.net/unsub.php // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Excel to Mysql
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 eres muy inteligente ? >Desengañate jugando ... > http://www.atrivia.com > __ -- Wayne Bastow - DBA - Central Coast Health Phone: 61 2 43203231 Email: wbastowATccahsDOThealthDOTnswDOTgovDOTau Linux, the choice of a GNU generation Kernel 2.2.16-22 on a i686 Running Windows on a Pentium is like having a brand new Porsche but only be able to drive backwards with the handbrake on. (Unknown source) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Excel to Mysql
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 > __ Probably the easiest way is to save the Excel data as a dBase table, then import the data using something like dbtool (see mySQL contributors page). I use dbtool for a dBase file and it worked fine. DM -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Excel to Mysql
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 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 > __ PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Excel to Mysql
> 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
