Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Update mySQL data from Excel
January 12, 2007, 8:22 pm
rate this thread
do something with this data and then send it back to mySQL.
Company heads love the spreadsheet view so this is serious business.
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.
Re: Update mySQL data from Excel
Since you're working with Excel, let VBA help.
Instead of trying to show the data in the browser, you could try:
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.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum