I am using Access 2010 to transform some data from an Essbase pull in Excel. I want to be able to just copy and paste the raw data, then have Access change the date from a text of "Jan" to actual date format of 1/1/2014.
Is there an easy way to do this in Access 2010?