Re: Help Export Excel to MySQL database
| From: | Johannes Janson | Date: | Wed, 28 Mar 2001 09:36:27 +0000 |
| Subject: | Re: Help Export Excel to MySQL database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-7929@lists.php.net to get a copy of this message | ||
Hi,
you can save it as .csv or as a tab-delimited .txt file.
then via "load data infile 'path/to/file' into table YourTable"
if you use windwos the "\" has to be escaped by another "\"
like this "C:\\path\\to\\file"
Johanens
""John"" <nagasea@kaskus.com> schrieb im Newsbeitrag
news:99ra37$dj8$1@toye.p.sourceforge.net...
> how to export the text files to Msql database ?
> My database now in Excel format.
> what type of file should I saved
>
> I will insert the file in MySQL
>
>
>
> --
> 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
>