In the original data file (text file - csv format) one of the fields has date
data and it looks like this: Jan-06. When I select "text to columns" and
parse the data, the format of this field changes and looks like this: 6-Jan.
I need to import this data into access and this date field is causing
problems. I tried manually changing the format back to its original form but
when I save the file and then go back into it, it shows up as 6-Jan again.
How do I keep the formatting from changing when I parse the data? Thanks.
Any help is appreciated.
--
Terri