Open Script Solution

A few days ago, a friend of mine asked me for help. He wanted to export his data from Excel file into Access database file. There were about sixteen thousand rows in Excel that have to be exported into Access. One of the columns in that Excel had a Date data. Unfortunately, most of those rows have the 5 digits numeral data, and not in the real Date Value data. For example, there was a row with value ‘38353. As we know, this is not a valid Date, right? Besides that, there is a ‘ character before the value itself. In this case, that value become a String and not a numeral value anymore. Read more…