[PHP-DB] Excel to MySQL
Hello, I have an Excel worksheet with a database in it. I would like to move this data to the database on the server that would work with my .php files. Is there a way? I apologize if I posted this question on the wrong list. Thank you, Masud Hasnain - Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more.
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
[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
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
[PHP-DB] Excel to Mysql
Is it possible to migrate data into a table in MS Excel to MySQL? Thanks in advance. Daniel Berwig -- 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]
SV: [PHP-DB] Excel to Mysql
I am sure there are several ways of doing this. What I do, is just save the excel file as a tab-separated txt file... Then in mysql you call the LOAD DATA local infile /tmp/test.txt into tabel tablename (columnname1, columnname2) ; I have made a little upload script for this.. If you want it I can mail it to ya.. msg me off list. -- trond -- -Opprinnelig melding- Fra: Daniel Berwig [mailto:[EMAIL PROTECTED]] Sendt: 20. november 2001 19:25 Til: [EMAIL PROTECTED] Emne: [PHP-DB] Excel to Mysql Is it possible to migrate data into a table in MS Excel to MySQL? Thanks in advance. Daniel Berwig -- 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
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 ? Desengaate 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]
