| |
Research LogTue 17 Feb 09I've just been trying to migrate some swarmtv info from Access to mySql. It's taken ages to find out how to do it, but here's how: Install MAMP Go to phpMyAdmin and create your table that you want to import your info into. Then go into your Access database and export the table you want to migrate into a CSV file. Click on Advanced button Make sure you delimityour fields with a ; And that you qualify your text with a " Make sure you list any dates as YMD and as four digit years (YYYY-MM-DD HH:MM:SS) Delimit your date with a - Check leading zeros in dates Delimit your time with a : Click OK Click Finish Now inside phpMyAdmin go to the database with the empty table inside and select the database and table you want to import into on the left panel. Ask it to import your CSV file, browse to the file you want to import and Click OK Check the CSV using LOAD DATA box And terminate your lines with \r\n Check your fields and click GO Voila! PhD Year 3 Research February 2009 PhD Year 2 Research October 2008 Research July 2008 Research June 2008 Research May 2008 Research April 2008 Research March 2008 Research February 2008 Research January 2008 Research December 2007 Research November 2007 Research October 2007 Research September 2007 PhD Year 1 Research August 2007 Research July 2007 Research June 2007 Research May 2007 Research April 2007 Research March 2007 Research February 2007 Research January 2007 Research December 2006 Research November 2006 Research October 2006 Research August 2006 MA Year 2 Research July 2006 Research June 2006 Research May 2006 Research April 2006 Research March 2006 Research February 2006 Research January 2006 Research December 2005 Research November 2005 Research October 2005 Research September 2005 Year 1 Research August 2005 Research July 2005 Research June 2005 Research May 2005 Research April 2005 Research March 2005 Research February 2005 Research January 2005 Research December 2004 Research November 2004 October 2004 Research September 2004 |
||||||||