View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
FUBARinSFO[_2_] FUBARinSFO[_2_] is offline
external usenet poster
 
Posts: 13
Default Importing .csv with #2000-04-06 10:15:00# date format field

Dave and Joel:

Yes, the simple search/replace of '#' with '' fixes things up after
import. I just thought there was an embedded way or setting that I had
overlooked that would have enabled recognition of the #..# form of the
date as a date. 'Write #n' does this, 'Print #n' does not (but
'Print' has the disadvantage of expanding tabs to spaces.)

I'm sure this output format is an artifact of an earlier database
convention of Microsoft's, I just can't recall which it is at the
moment. But evidently it's one that Excel, 2003 version, no longer
recognizes.

Thanks for your help.

-- Roy Zider