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

Stiebel Eltron
Stiebel Eltron used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012
Commented:
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.

Author

Commented:
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).
Top Expert 2012

Commented:
Then try converting it using the instructions in the link I gave you.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Will it work with Windows 7, 64bit system?
Top Expert 2012

Commented:
Looks like MySQL Workbench only has 32-bit installers but why not just find out for yourself?

Author

Commented:
Ok, will do... thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial