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 Quote Link to comment 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 Quote Link to comment 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.