Exporting blog posts

I'm trying to export out historical blog posts for a particular user to be imported into a Wordpress site.  Is there an ideal way to do it, or is it necessary to run some SQL scripts to extract the posts and include them with images from the files directory?