Amend Format In Table

[mosh]

All,

I have a table that has dates in three fields. The problem is, when I imported them, it was done as a text format. The format is xx.xx.xxxx, I want it to be a short date; i.e. 01/01/2008.

I have tried converting it through the table design view, but it says not enough memory. How can I go about updated this field?

Thanks.
________
Water bong

 

[mosh]

all,

found a solution - exported as a .txt file, re-imported back into access and amended date's to correct format.
________
WEB SHOWS