how to convert field with data type Text into Date/Time format

[tasam21]

In my table i have a field with list of record like 12091999 as a type Text. how can i change all the record under that field into format like 12/09/1999 by giving Date/Time data type.

[orange]

An approach would be:

Create a new field in your Table with type Date, say MyDate.

Create a query with the text field in question ( the string "12091999"). Let's say this field is txtDate.

UPDATE testCharDate
SET testCharDate.MyDate = CDate(Left([txtField],2) & "/" & Mid([txtField],3,2) & "/" & Right([txtField],2));