RE: [PHP-DB] Excel to MySQL?? From: Beau Lebens (B.Lebens <email protected>)
Date: 06/30/02

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:chase <email protected>]
// Sent: Sunday, 30 June 2002 5:57 AM
// To: php-db <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
// > info <email protected>
// > tel. 0121-242-1473
// > -----------------------------------------------
// >
// >
// >>-----Original Message-----
// >>From: Chase [mailto:chase <email protected>]
// >>Sent: 29 June 2002 22:22
// >>To: php-db <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