How to best connect Excel to a hosted MySQL installation?
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$6 Answers
Here's this myodbc thing that seems like it may do what you ask http://www.automateexcel.com/2005/11/01/connect_excel_to_mysql_database/ but I don't think you necessarily need another tool (see previous paragraph)
But I have three questions:
1. First, have you verified that you will be able to connect using ANY application (such as Mysql administrator or the mysql command line) to your hosted mysql database server? You would need the hostname or ip, port, username and password. This may be an option on your account you have to set or it may not be allowed at all. Depends on your host and the type of account.
From reading your question and this stuff in your reply
"Also, this is about simultaneous multi-user lookup of data during a transaction, so the CSV route is not feasible. I'm considering Access, but need to do very heavy computations, thus I need Excel"
2. Now I'm curious, what are you actually doing? Usually when it gets that involved the spreadsheet doesn't handle it alone well and one starts developing an application rather than trying to make Excel do everything. In that case the calculations might be in Java or C++ or Python or whatever and the application would access the DB through standard APIs. OR another common scenario is to have a layer of application code around your mysql database that this financial application might call through a web API.
But.. maybe what you are trying to do makes sense and will actually work if you can connect. Just doesn't seem the standard approach. Although I don't have any details.
3. What sort of transactions? Are they actually financial transactions??
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
An alternative is to write a php script that generates an html table and sets the content type of the page to automatically display in Excel.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$Check with your host whether your able to remotely connect to your mysql database.
my own knowledge
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
Alternately you can export your Excel data to a CSV file and use the tools in MySQL to import the data file.
"What i suggest you is to save your excel file in .CSV format and then import it from mysql."
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
Thanks, but my question centered around HOSTED mysql. I seem to not be able to connect to a hosted mysql installation whereas I can to a local one.
Also, this is about simultaneous multi-user lookup of data during a transaction, so the CSV route is not feasible.
I'm considering Access, but need to do very heavy computations, thus I need Excel. I cannot replicate the Excel formulas in VBA in Access. Impossible...
http://support.yessoftware.com/kb_article.asp?article_id=26
http://www.filetransit.com/files.php?name=Mysql
http://www.stardeveloper.com/articles/display.html?article=2003101901&page=2
http://www.eggheadcafe.com/software/aspnet/33131256/pulling-data-from-mysql-d.aspx
http://www.vicman.net/download/9790/
http://free-mysql-client.qarchive.org/
this will help you i think
http://ask.metafilter.com/56454/How-to-easily-searchreplace-in-MySQL-database
http://ask.metafilter.com/tags/shareware
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
Ok it doesnt let me reply to you reply so I will write it here. Maybe Excel will work for that.. I mean it certainly is flexible and easy to do calculations with.
Does the version of Excel you are using handle the concurrency issues as far as having many users getting a live view of data? I think Microsoft is trying to address that with their newest or Live version or something and if not there is also stuff like Google docs spreadsheets or this EditGrid thing which were specifically designed to handle that aspect of it.
Thanks for your feedback -- it helped me to find out about HTTP tunneling and why I need that for GoDaddy and 1and1. I have not tried it yet, though.
Our current GoDaddy database is accessible through PHP, so I know we can get to it.
I'm implementing an operator interface to a php/Java web application that many of our customers will use. The operator interface in Excel will allow operators (note the plural) to look at the data that is pertinent to them, do some heavy computational data crunching, allocate resources based on that data crunching and then write the resource allocation back into the database, so allocated resources are accessible to customers. Some of these resource allocations take place within seconds after reading the data, some within minutes, but all need up-to-date data to make decisions and then write back in real-time whatever decision was made. Eventually, as we solidify certain aspects of the operator interface, it will get "set in stone" (meaning, it will be programmed in PHP and Java), but the flexibility of Excel will always be needed. And yes, we are talking about transactions that involve money...