Importing date field in a large txt file
I typically import a text file of 3.5 million records using a pre-existing import spec file. However, I have several pending project for which I will have to query on date criteria. Currently data fields import as text.
If I try to change the datatype of the field, all the data is erased. If I try to change the import spec for this field from text to date, all the data is erased. I am very discouraged, stressed out, and devoid of ideas.
1) Will I be able to set criteria and return dates between two value if this field remains text? I doubt it.
2) Why can't I change the datatype from text to date in an existing field?
3) When I change the import spec (only change is the single field datatype from text to date) why isn't the data imported?
4) the text file looks like ...,"19520701","next field data", and yes, even though the text file is cvs the existing import spec is creates field deliminated format, and yes, I created a short file and deleted the " from the txt file with the same result.
Any insight, wisdom, suggestions, folk sayings, etc. would be most gratefully received.