Importing node_revisions records from version 5 to version 6 Probably a dumb question, but could I simply export an SQL file from the database of a Drupal 5 site and import it into a Drupal 6 database in the same table provided I used the same CCK fields for both? I've tried to migrate content in so many different ways and pretty much everything has failed so far... importing csv through the feeds module was my greatest hope and was made to look so easy but I keep getting an HTTP error.

Also is node_revisions the table that contains all of the stories? I tried exporting nodes, but it didn't seem to contain the body field.
Instead of trying some convoluted way of exporting and then re-importing the data and maintaining all meta-data - have you tried simply upgrading the site to Drupal 6?

This has been heavily documented on drupal.org

When you do a major drupal upgrade, so long as there is a drupal 6 module for your functionality, there will be update hooks that alter the database to convert it to the new schema.

This includes CCK, revisions etc