yoursurrogategod Posted January 10, 2013 Share Posted January 10, 2013 Has anyone tried? I'm currently trying to output the entire thing as a TXT file and go from there. Quote Link to comment https://forums.phpfreaks.com/topic/272956-how-to-convert-from-access-to-mysql/ Share on other sites More sharing options...
yoursurrogategod Posted January 10, 2013 Author Share Posted January 10, 2013 Or how about converting CSV to MySQL? I figured out how to get a CSV file out of my Access database. Quote Link to comment https://forums.phpfreaks.com/topic/272956-how-to-convert-from-access-to-mysql/#findComment-1404733 Share on other sites More sharing options...
cpd Posted January 10, 2013 Share Posted January 10, 2013 You can import CSV files using phpmyadmin if you've got it installed on your server. Quote Link to comment https://forums.phpfreaks.com/topic/272956-how-to-convert-from-access-to-mysql/#findComment-1404740 Share on other sites More sharing options...
mikosiko Posted January 10, 2013 Share Posted January 10, 2013 MySqlworkWench has a Database Migration feature that you could try http://dev.mysql.com/downloads/workbench/ Quote Link to comment https://forums.phpfreaks.com/topic/272956-how-to-convert-from-access-to-mysql/#findComment-1404787 Share on other sites More sharing options...
Barand Posted January 10, 2013 Share Posted January 10, 2013 Quote Link to comment https://forums.phpfreaks.com/topic/272956-how-to-convert-from-access-to-mysql/#findComment-1404796 Share on other sites More sharing options...
DavidAM Posted January 11, 2013 Share Posted January 11, 2013 I just loaded an ODBC driver for mySql, then linked the mySql tables into Access and ran INSERT queries to transfer the data. Of course, I had to create the mySql tables manually, first. Quote Link to comment https://forums.phpfreaks.com/topic/272956-how-to-convert-from-access-to-mysql/#findComment-1404864 Share on other sites More sharing options...
fenway Posted January 13, 2013 Share Posted January 13, 2013 I also keep reminding everyone about the CSV engine type. Quote Link to comment https://forums.phpfreaks.com/topic/272956-how-to-convert-from-access-to-mysql/#findComment-1405386 Share on other sites More sharing options...
yoursurrogategod Posted January 22, 2013 Author Share Posted January 22, 2013 (edited) Ok, I had this figured out for a few days, but forgot about this thread. Basically my problem was that when I exported the CSV and tried to import it into MySQL, phpMyAdmin would bomb (Internal Server Error, that was all the information). Very weird. However, there were over 614,000 records (lots). So, I did something different, I split up the info into smaller pieces and inserted it in smaller pieces (did 400,000 at a time). That worked. Thanks guys for your help. I have new ideas now in case I need to approach this problem from a different perspective . Edited January 22, 2013 by yoursurrogategod Quote Link to comment https://forums.phpfreaks.com/topic/272956-how-to-convert-from-access-to-mysql/#findComment-1407512 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.