SV: [PHP-DB] Excel to Mysql
| From: | Trond Erling Hundal | Date: | Tue, 20 Nov 2001 17:23:27 +0000 |
| Subject: | SV: [PHP-DB] Excel to Mysql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14476@lists.php.net to get a copy of this message | ||
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:grafbi02@terra.com.br]
> Sendt: 20. november 2001 19:25
> Til: php-db@lists.php.net
> 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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>