Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to revise the attached MS Access db to MySql db?

Posted on 2012-04-10
6
Medium Priority
?
428 Views
Last Modified: 2012-04-10
Dear EE experts,

We would like to ask for tech support on how to revise the attached ms access file into mysql db. We need to change our db to mysql as our host doesn't support MS Access, and we need to connect that db with our PHP & ASP files...

Please see the attached file...

Thank you & hope to hear soon...
products-asia.mdb
0
Comment
Question by:Stiebel Eltron
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 24

Accepted Solution

by:
johanntagle earned 2000 total points
ID: 37830988
I haven't used it but MySQL Workbench has a feature to help you convert/import an access database.  http://www.hosting.com/support/mysql/amconversion, among other pages on the web, seems like a good starting point for you.
0
 

Author Comment

by:Stiebel Eltron
ID: 37831032
Hi there johanntagle!

We need to convert that in order for us to use it to our GoDaddy host. That only supports MySql & SQL Server (for our chosen host plan).
0
 
LVL 24

Expert Comment

by:johanntagle
ID: 37831037
Then try converting it using the instructions in the link I gave you.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Stiebel Eltron
ID: 37831039
Will it work with Windows 7, 64bit system?
0
 
LVL 24

Expert Comment

by:johanntagle
ID: 37831050
Looks like MySQL Workbench only has 32-bit installers but why not just find out for yourself?
0
 

Author Comment

by:Stiebel Eltron
ID: 37831099
Ok, will do... thanks!
0

Featured Post

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question