Yohanne Posted September 7, 2013 Share Posted September 7, 2013 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? Link to comment https://forums.phpfreaks.com/topic/281946-ms-access-2003-to-mysql/ Share on other sites More sharing options...
PravinS Posted September 7, 2013 Share Posted September 7, 2013 Try using SQLyog https://www.webyog.com/product/downloads you can import MS Access database in SQLyog Link to comment https://forums.phpfreaks.com/topic/281946-ms-access-2003-to-mysql/#findComment-1448561 Share on other sites More sharing options...
jcbones Posted September 7, 2013 Share Posted September 7, 2013 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://http://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-export.html Link to comment https://forums.phpfreaks.com/topic/281946-ms-access-2003-to-mysql/#findComment-1448614 Share on other sites More sharing options...
Yohanne Posted September 12, 2013 Author Share Posted September 12, 2013 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? Link to comment https://forums.phpfreaks.com/topic/281946-ms-access-2003-to-mysql/#findComment-1449174 Share on other sites More sharing options...
priyankagound Posted September 17, 2013 Share Posted September 17, 2013 This might help you; the article is old, but I believe it should still be relevant. http://www.kitebird.com/articles/access-migrate.html Link to comment https://forums.phpfreaks.com/topic/281946-ms-access-2003-to-mysql/#findComment-1449820 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.