Hi All.
I have an excel file that needs to be imported into access.
I get error when importing as one column is general type in excel, but stores mostly date values ( in dd-mmm-yyyy format.) Some of the records in that column in excel have text values like "till delivery date", "upto warranty" etc... instead of dates which is a big headache.
12-jun-17
29-sep-16
till delivery
15-oct-12
13-mar-16
How do i import into access all records as text and then use the date part in queries in access as "till delivery" needs to be printed as it is; if date does not exist.
Hope I'm clear.
Any help appreciated.
I have an excel file that needs to be imported into access.
I get error when importing as one column is general type in excel, but stores mostly date values ( in dd-mmm-yyyy format.) Some of the records in that column in excel have text values like "till delivery date", "upto warranty" etc... instead of dates which is a big headache.
12-jun-17
29-sep-16
till delivery
15-oct-12
13-mar-16
How do i import into access all records as text and then use the date part in queries in access as "till delivery" needs to be printed as it is; if date does not exist.
Hope I'm clear.
Any help appreciated.