rattler Posted November 21, 2011 Share Posted November 21, 2011 Hello, I have been given the task of adding a section to an existing website. The new section has to use data stored on a local access database but the existing site runs on MySQL. What would be the best way of getting the local information to the servers database in the correct format etc? Thanks in advance Link to comment https://forums.phpfreaks.com/topic/251535-access-to-mysql/ Share on other sites More sharing options...
joel24 Posted November 21, 2011 Share Posted November 21, 2011 export the access file as a CSV, create the new table on your server, upload the csv file and read it into the database using the load data infile function Link to comment https://forums.phpfreaks.com/topic/251535-access-to-mysql/#findComment-1289961 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.