Export to MS Excel

Anon

Hi,
I got a table on MySQL under Linux and i just want to know if it's possible to export it to MS Excel or MS Access.

I got another server (IIS) under WinNT which i can use.

Please HELP !
🙂

Anon

...if you want to do it manually, you can simply dump the table and import it into excel using the separator you used to dump your data (most likely the ';') ... if you don't know how to dump the data, use PhpMyAdmin for that, it does the dirty work ...
if you want to have the import automaticly, i guess you need to do some vba ... shouldn't be that hard ...
hope that helps
cya Rob

Anon

Hello,
a simple way:
try to load you data into a CVS database. That you can use with Excel for sure, and I think with Access too.
Regards, Kornel

Anon

i try to build automatically and give to donwload to the user
is it possible ?

Anon

well if you want to generate excel files, i think that can't be handled by PHP alone... I would do it sort of this way:
-have a PHP/cronjob that puts out your table to csv data like kornel mentioned (don't know how often you need it but that you can controll via the cronjob)
-build a vb/vba application that imports the csv data into excel an saves it (this one i would run 1/2 hour after the cronjob started ... i think there i something similar to cron on windows)
but don't ask me on the vb/vba part (its part of my dark microsoft past, which i don't want to wake up 🙂)
hope that helps
cya Rob

firake

You can actually create the data in csv format (comma-separated) by adding comma for every column and new line for every row

To send them out for download using header();

header ("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=filename.csv");

even though somehow this does not work in Netscape!

Anon

Yes importing into Access can be done with the MyODBC driver. You can download the program for free at the mysql site and there are some tutorials on the internet somewhere to get it working.

MyODBC lets you connect Access (frontend) to MySQL (backend) on the remote server and then it automatically creates the table and dumps the data into it on access. Then you can export that data to excel, query it, or whatever.

That should be the easiest way to get it working. That's how I did it and it works great. You just connect to the internet, click a few buttons and the data is right there in access.

maxpup979

Give this a shot--

header ("content-type: application/vnd.ms-excel");
header("Content-Disposition: filename=whatever.xls");