RE: [PHP-DB] Importing Excel and Access data to MySQL
| From: | Bomgardner, Mark A | Date: | Fri, 08 Oct 2004 13:13:41 +0000 |
| Subject: | RE: [PHP-DB] Importing Excel and Access data to MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36685@lists.php.net to get a copy of this message | ||
The best way I have found is convert the data to a comma separated value
file, use phpMyAdmin and insert the data into you database. A couple of
things that you have to watch out for is the number of records that you
are importing and that all your fields in your DB are of the correct
format and length.
Mark A. Bomgardner
Technology Specialist
KLETC
-----Original Message-----
From: Matthew Perry [mailto:mwperry@mail.uh.edu]
Sent: Thursday, October 07, 2004 9:46 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Importing Excel and Access data to MySQL
Simple question,
How does one import excel and access data to MySQL?
-- Matthew Perry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php