OIC....Let me experiment with a workaround and I'll reply back to this message shortly.
>Let me give you an example of the problem I am having.
>
>01/01/2000 imports as {01/01/0020}
>
>01012000 imports as {01/01/1900}
>
>010100 imports as {01/01/1900}
>
>01/01/00 imports as {01/01/1900}
>
>Thanks, Chris
>
>Yes, VFP will pull in *any* dates if formatted MM/DD/YYYY.
>
>
> >It can be what ever I choose. That is part of my question. How do I need to farmat it? Is it possible in 6.0 to pull in 2000 dates?
> >
> >What I hac done historically is append into a character field then convert that to a date.
> >
> >However, the file are quite large and I am looking for a better way.
> >
> >
> >>What is the incoming format of the text?
> >
> >> >Yes, but I need the century to say 2000.
> >> >
> >> >Thanks, Chris
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05