mysql - Excel
what I do very often an what really works great is (escpecially when
customers need some download feature for db data for word/mail/excel
processing and have no sql/phpMyAdmin knowledge)
build a html data table using php:
// file download_table.php
<table>
<?php while (...) ?>
<tr>
<td>value1</td><td>value2</td>
</tr>
<?php } ?>
</table>
but instead of sending it to the browser as html file, send some
"special" headers at the beginning of your script:
Header("Content-Type: application/vnd.ms-excel");
Header("Content-Disposition: attachment; filename=\"$filename\"");
now your browser "recognizes" the arising download of an excel file and
asks you whether to downloading to disk or to open using excel :-) as
excel is great in html :-P , it activates its html import filter and
that's it!
this method is very useful
- with complex queries
- as a download feature for "dumb users"
mysql - Access
Access is able to "get external data" out of an excel table...
if you know more about the other way (excel/access -> mysql).
what if you tried to access your mysql db from excel/access via the
myODBC driver ?
HTH steff
Rosen Marinov wrote:
> Hi,
> How can I import/Export data to MySQL database using PHP following formats:
> EDI, Access, Excel ?
>
> Where can I find information about this ?
>
> Thanks,
> Rosen Marinov
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
