The biggest way in which Access 2007 is genuinely worse?  How it imports and exports CSVs.  There are some cryptic things it does with field truncation and character translation that I simply don't understand.  (The import/export wizard is frustrating, too.)

Does someone have VBA code that handles importing and exporting CSVs well?  I'm already using this, but would love some other pointers if they're out there.  Email me at acumen at gmail dot com if you've got something good.