My users receive various CSV, TXT, and TSV files in various formats and from
various sources and they are in the habit of double clicking (or right click
- Open with) the files to open them in Excel. Excel then interprets all the
text value and applies a General format without warning the user. This
results in data corruption when it guesses wrong. EG an account code of
"1sep" gets corrupted into a date value of "9/1/2009" or a ZIP code string of
"08651" is converted to an integer "8651". How do I disable this 'feature' or
change the default type to Text?

I realize one can import with the Wizard as a workaround as well as writing
specific import macros but this is not the solution I am looking for.