Originally Posted by
Ajax
I suspect it is not the records being deleted but the field being set to null. The reason is probably because the text value does not conform to a short date.
If this is a one time conversion, or just as a learning exercise to work out how to handle exceptions for future imports, do the following.
1. Create a new date/time field in the table - call it say newDate
2. Create an update query to update newDate with the value from your shorttext field
3. run it - ignore any errors
4. open the table and filter it on the newDate column to only show nulls (or sort it if you prefer)
5. inspect your shortdate columns for the values and then either manually add the dates or modify your update query to cope with them and run it again
6. Once done, either rename or delete the short text column, then rename the newdate column
This usually comes about because an excel user has mistyped a date or put something like 'unknown' or 'tbc'