PLEASE HELP I need help creating an update query in aces 2010 to convert from text to date time. I have an excel spreadsheet file that Im importing into access as Date/Time but I keep getting an error about about data mistmatch and have no idea what causing it. I created an update query and used the Format([tablename]![tablefield] 'mm-dd-yyyy') and still didn't work.

Can anyone help please?