Creating secondary field to put data that doesn’t fit primary field’s data type

I’m trying to import an existing excel file that has a mixture of date formatted data (mm/dd/yyyy) and standard text such as “N/A”, “yes”, “no”, and “mm/dd/yyyy, mm/dd/yyyy”. I tried to just import this data as a short text data type, but then I lose the ability to sort from oldest to newest dates as access is reading it as text. My thought was to have a 1st field using the date data type and then a 2nd field using short text that will import every cell that doesn’t fit in the date field. Is this possible? Is there a better way of doing this that I am missing?

submitted by /u/MT_CR_123
[link] [comments]

Posted on