You could just use MysqlODBC, and import the data right into the excel 
sheet. 

Just setup a DNS that points to your Mysql server, on the windows box, 
then select Data->Get External data->New Database Query within Excel... 

I'm not sure what the data is, or why you need the data, or what your 
really doing....

But that might be in option...


Cheers!!

Dan



-----Original Message-----
From: roehr [mailto:[EMAIL PROTECTED]
Sent: Monday, May 24, 2004 9:47 AM
To: php-db
Subject: Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file


<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
...
> Thanks for responding, Torsten. If I'm understanding your suggestion, 
then
> what happens where the data from the dB already has a ; (semi-colon) 
in
> it? Wouldn't this corrupt the import into excel?

This might cause a problem because Excel will start a new row then - 
this
could also happen with a tab delimiter. At the moment I can't think of a
solution for this. Is it probable that your data contains semicolons?

Regards, Torsten

-- 
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

Reply via email to