Research Log

Tue 17 Feb 09
I'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