Given an older CMS that kept data in a mysql database, how could we move this into a new D7 install?
It has a mysql database with a content table containing
Body (with HTML content) columns, could I do an import of this into Drupal and fill in the gaps as needed? I'm okay to rebuild menus and tie up other loose ends, but I'm fearing hours of cutting and pasting putting.
Follow Up and Outcome
:** After considering all the great advice below, I opened the older database in mysql Query Browser, executed a query on the profiles table to give me a CSV file with the following headers...
Then I created a Feed Importer with the following mapping: