The [Feeds][1] module support CSV files without column headers.  On admin/structure/feeds/foo_importer/settings/FeedsCSVParser, you just need to select "No Headers".  Then on admin/structure/feeds/foo_importer/mapping, you use the column numbers for the source.

  [1]: http://drupal.org/project/feeds