RE: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

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:roehr@zilleon.com] Sent: Monday, May 24, 2004 9:47 AM To: php-db Subject: Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file <dpgirago@mdanderson.org> wrote in message news:OFC05C8DC9.D82DB981-ON86256E9E.00504BC9-86256E9E.0050B6E8@mdacc.tmc.edu ... > 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