Access 2007 "Data Type Mismatch Criteria Expression"
Posted on 2013-02-01
Good day. So I have an Access database that I use to produce some reports and store data. I receive a CSV file every month which contains the data, I have a module that I run to import the data, process it by moving the current data in a table to another table which contains all the archived data, then I import the CSV data in the existing table.
Well, today i received the file and after importing the data and attempting to run the report, I receive an error stating "Data Type Mismatch Criteria Expression".
I took a look at the file and it seems like the date fields changed. They changed as follows:
From: Mon May 3 21:00:00 GMT-0700 2010
To: 11/23/2010 20:07
Any idea what changes I would need to make to get the reports to work?