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? Quote 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 Quote 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 Quote 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? Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.