It seems that if it finds one field in a column that looks as though
it could possibly be a date, then it will treat other fields in that
column as dates too, and store them as numerals.

So even if it is formatted to *display* as text, as entered, if one
pronts it, or saves it in a a CSV style, it will print or store the
wrong value.

So for 1 *last time*...

If you *do not* use Excel's methods to import/output the data, but use
VBA standard file I/O methods OR ADODB, the data transfers *'as is'*
without being changed by Excel.

Using Excel's import methods gives Excel license to *interpret* data
type! As you're experiencing here this is not what you want to happen*!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion