Export it as a delimited text file, I like to use | as a delimiter because it isn't going to appear in your text (as opposed to a comma which could).
Then you can write a simple import script.
php's file() function parses each line of a text file into an array, so do that and it'll put each record into an array. Then you can use the array walk function to process each record and insert it. Here is an example I've used.
<?
$quotelist = file("$url");
$db = mysql_connect("localhost", "username", "password");
if (!$db) { echo( "<P>Unable to connect to the " . "database server at this time.</P>" ); exit();}
mysql_select_db("quotes", $db);
function addquote($element){
$quote_array = explode("|",$element);
$author = $quote_array[0];
$quote = $quote_array[1];
$attribution = $quote_array[2];
global $db;
$result1 = mysql_query("INSERT Into quotes SET author = '$author', quote = '$quote', attribution = '$attribution'", $db);
if (!$result1) { echo("<P>Error performing query: " . mysql_error() . "</P>");
exit();
}
}
array_walk($quotelist, 'addquote');
?>
What you'd do is pass the script an argument called "url" which is the location of the text file.