How to convert to date/time in MS ACCESS with this format 20110916160401
Posted on 2011-09-19
Hi I have csv files I need to start importing into an access database. One of the columns in the csv is the date/time, but the column is just a number like: 20110916160401 which I think is year(2011), month(09), day(16), time(16:04:01)
Is there a way to configure the MS Access 2007's table column as Data/Time to convert this string to correct date/time?
Thanks for any input.