467,920 Members | 1,173 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,920 developers. It's quick & easy.

exporting mysql to excel or filemaker pro

100+
Hi all,

Is it possible to

1) export (and force download) of multiple mysql tables to 1 excel file with multiple sheets

or

2) export (and force download) of 1 mysql table to a filemaker pro file

I can export to csv but not these other two.

Any advice appreciated,

Thanks
Dec 3 '07 #1
  • viewed: 1602
Share:
4 Replies
100+
hi,
I suggest you to try SQLyog (http://www.webyog.com) for this.

Regards,
Xoinki
Dec 4 '07 #2
100+
hi,
I suggest you to try SQLyog (http://www.webyog.com) for this.

Regards,
Xoinki
Xoinki,

Thanks a lot for your reply. I have downloaded and started using sqlyog, and I can confirm it is easy, intuitive and does the job.

However, I wasn't clear enough in my request. sqlyog works for me personally, but what I need is a script (or snippet) which I can have on my site which will enable any user, via the click of a button or two, to export *their* table data to an excel file and force it to download for them on their own computer. It's my fault for not making this clear initially.

If you, or anyone else, knows how to do that, I'm all ears.

Thanks again.
Dec 4 '07 #3
mwasif
Expert 512MB
Checkout this class to export excel http://www.phpclasses.org/browse/package/644.html.
Dec 4 '07 #4
100+
Checkout this class to export excel http://www.phpclasses.org/browse/package/644.html.
Thankyou mwasif! Looks like just what I need. Cheers.
Dec 4 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Andy Levy | last post: by
2 posts views Thread by Damien | last post: by
1 post views Thread by Mustufa Baig | last post: by
1 post views Thread by cmgmyr | last post: by
1 post views Thread by ndedhia1 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.