I am having problems with an Excel spreadsheet that I have imported into Access.
One of the fields contains an assortment of dates (eg 3Q 2000, 01/05/99, Begining 2000) these dates need to be stored as text.
However, some of the dates imported from Excel come across as a number instead of a date. Is there any way I can convert this to date format without changing the field type?
One of the fields contains an assortment of dates (eg 3Q 2000, 01/05/99, Begining 2000) these dates need to be stored as text.
However, some of the dates imported from Excel come across as a number instead of a date. Is there any way I can convert this to date format without changing the field type?
