Help needed: good CSV-import/-export code for Access 2007

posted Sep 28, 2010, 12:35 PM by Ezra Kenigsberg   [ updated Sep 28, 2010, 1:56 PM ]
I dunno about you, but I think Access 2007 is only a middling improvement on Access 2003 -- and in some ways, it's genuinely worse.

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.