469,326 Members | 1,224 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Update mySQL data from Excel

Ok I know how to get the data I want from mysql but I need to actually
do something with this data and then send it back to mySQL.

Company heads love the spreadsheet view so this is serious business.

I've done what I could with tables and css and javascript and whatnot
for a makeshift datagrid on a webpage but since I'm using PHP and not
asp.net I have no idea how to create a datagrid.

So if anyone knows how to update data in Excel that has been pulled
from mySQL it would be GREAT.

Thanks.

Jan 12 '07 #1
1 7441

ro**********@gmail.com wrote:
Ok I know how to get the data I want from mysql but I need to actually
do something with this data and then send it back to mySQL.

Company heads love the spreadsheet view so this is serious business.

I've done what I could with tables and css and javascript and whatnot
for a makeshift datagrid on a webpage but since I'm using PHP and not
asp.net I have no idea how to create a datagrid.

So if anyone knows how to update data in Excel that has been pulled
from mySQL it would be GREAT.

Thanks.
Since you're working with Excel, let VBA help.

Instead of trying to show the data in the browser, you could try:
http://pear.php.net/package/Spreadsheet_Excel_Writer

If your spreadsheet is very complicated (which could make the above
difficult to implement), you could always have the server create a CSV &
use some code in your spreadsheet to import it.

Going the other way, you could use some VBA code to write out an update
query - saving it as a file - upload it to some space on the server
(perhaps with a shell to a command-line ftp, though that would be
sending the login credentials as plain-text), then shell out to a
browser call using the uploaded file name as a query string.
Jan 13 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Philip Stoev | last post: by
3 posts views Thread by bawar | last post: by
4 posts views Thread by Piotr | last post: by
3 posts views Thread by Roy | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.