A company I work for has a lot of information stored in Access Databases. Ideally, we want this information on the web server so we can dynamically display tournament scores, points standings and more. So is there a way to connect a Microsoft Access database to a MySQL Database?
The answer, I found quickly, is yes.
I couldn't export the table data right away from my Access table, but after downloading the Connector/ODBC from the MySQL dev site, and following these simple instructions on the same site, I was able to connect to the MySQL server set up on my localhost with no problems.
This is exciting because now my company can use Microsoft Access as a front-end to our MySQL servers on our website.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment