In order to get information out of the database, you are going to have to have some sort of server running. If this is going to be accessed solely through your local network and not through the internet, then the solution you want may be to install Microsoft's IIS (internet information service - their version of a webserver) and PHP for IIS on the machine that hosts the Access database. You can then use PHP to pull data from the database and pass it along to the client.
If that is not feasible, then until you get the server space, your options are rather limited. You can hard code the data from the database in the javascript for the charts or write the javascript to accept a CSV file provided by the user, who will have to export the required data from the database manually. Another possibility would be to export the database to a Google docs spreadsheet and query that (the downside here is that you have to publish the spreadsheet, which means that your data would be publicly accessible to anyone who knows the URL of the spreadsheet). On Thursday, January 10, 2013 4:08:08 PM UTC-5, Person wrote: > > Hello all, > Here is my current situation. I am working on a project to > create a dashboard, but am having some trouble getting some server space > from my IT department. As a work around, I would like to do this all on > the client side. I need to connect to an Access Database on our local > network, and would like to create a Google chart based off that data. Can > someone hold my hand and walk me through this? Thanks. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/73jd0VFTfVUJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
