I have been handed an Access database with 1.4 million records. I didn't even think that was possible. The date field is text. Here is an example of a date, 20081001 What that date means is 01/10/2008. Is there any VBA that will go through the table and turn it into a date field without destroying the current data?
Any help is appreciated