>I have a delimited ascii file that I am importing via the import wizard. The data has dates in the format 01/01/00 which I
>wish to represent as Jan 1, 2000. After the import, if I "set century on" the years all show as 1900 instead of 2000. What
>can I do to import this correctly?
I haven't used import wizard at all so don't know how it works. Instead define the structure yourself threating date columns as char(8). Append data delimited (or SDF). Then execute :
alter table myTable alter column myDateColumn d
Cetin
