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"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
99ra37$dj8$[EMAIL PROTECTED]">news:99ra37$dj8$[EMAIL PROTECTED]...
> 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: [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]
