Jump to content


Photo

MS Access 2003 to MySQL?


  • Please log in to reply
4 replies to this topic

#1 Yohanne

Yohanne

    Advanced Member

  • Members
  • PipPipPip
  • 185 posts

Posted 06 September 2013 - 10:34 PM

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

PravinS

    Advanced Member

  • Members
  • PipPipPip
  • 430 posts
  • LocationNashik, India

Posted 06 September 2013 - 11:29 PM

Try using SQLyog

 

https://www.webyog.c...oduct/downloads

 

you can import MS Access database in SQLyog


Thanks & Regards,
PravinS | Blog


#3 jcbones

jcbones

    Advanced Member

  • Gurus
  • 2,566 posts
  • LocationNorth Carolina

Posted 07 September 2013 - 12: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

Yohanne

    Advanced Member

  • Members
  • PipPipPip
  • 185 posts

Posted 11 September 2013 - 08:07 PM

Hi,

 

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

priyankagound

    Advanced Member

  • Members
  • PipPipPip
  • 59 posts

Posted 17 September 2013 - 04:56 AM

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

http://www.kitebird....ss-migrate.html






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com