In excel, I have a column where the dates are stored in 2 ways:
1. Single date - 12/1/2002
2.Categorized - 2002, December, single days - these need to be drilled down by checking the "+"
Access imports 1. successfully, but not 2.
Please offer how I can change the format in 2. to 1.
Selecting the entire columns, and changing date format does not work.