Jump to content


MS Access 2003 to MySQL?

  • Please log in to reply
4 replies to this topic

#1 Yohanne


    Advanced Member

  • Members
  • PipPipPip
  • 202 posts

Posted 07 September 2013 - 03:34 AM

Hi Coders,


In the help of this forum and the following member, i get to present my work successfully and i am very thankfull. but now my boss suggest me and he get change his mind.


this is: the company is there are 100 more or less store nationwide here in the philippines. the company has already a software called it MYOB. this software is not online, the use of this software is for sales transaction, the software is use an old database MS ACCESS 2003. now it possible to import the datatable from MYOB to MySQL automatically the web page is to  set the autoload/refresh in every 1/2 hour to get the file form MYOB.




Please advise me, what should i do first since this is my first time to do this?  

#2 PravinS


    Advanced Member

  • Members
  • PipPipPip
  • 455 posts

Posted 07 September 2013 - 04:29 AM

Try using SQLyog




you can import MS Access database in SQLyog

Thanks & Regards,
PravinS | Blog

#3 jcbones


    Advanced Member

  • Gurus
  • 2,653 posts
  • LocationNorth Carolina

Posted 07 September 2013 - 05:27 PM

You should be able to export the data via .csv files, or the ODBC connector available i MS Access.


MySQL has documentation on that... http://dev.mysql.com...ess-export.html

#4 Yohanne


    Advanced Member

  • Members
  • PipPipPip
  • 202 posts

Posted 12 September 2013 - 01:07 AM



So.. do you mean store personnel should be the one to open up the database to export it? is there is no other way that store personnel cannot touch the database? 

#5 priyankagound


    Advanced Member

  • Members
  • PipPipPip
  • 59 posts

Posted 17 September 2013 - 09:56 AM

This might help you; the article is old, but I believe it should still be relevant.


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users