Updating data type field

[djmousie]

I have an access table that is over 2 million records. I can't chage the data type on one of my fields because i am getting an error message stating that there isnt enough space or memory...

1 - Is there a work around?
2 - If not, can an update query be written so that I can update the data type so that a particular field is updated to be General Date vs. Text?

 

[djmousie]

3 - Or possibly only update so many records at a time so it doesnt run out of memory?

 

[JerryKlmns]

djmousie,

Create a new field of Date data type and then run this query

UPDATE YourTableName
SET YourNewDateField = YourNonDateField
WHERE IsDate(YourNonDateField)=True

YourNonDateField format could be
mm/dd/yyyy, mm-dd-yyyy
dd/mm/yyyy, dd-mm-yyyy
yyyy/mm/dd, yyyy-mm-dd

 

[djmousie]

I'll give that a try.
Thanks