append with dates

[James]

I am trying to append a converted .dat file into a free table in VFP6. How
do I get the date fields in the .dat file to import properly into the VFP
table. It works through the wizard but not through an append. My .dat file
is delimited by character ! . Right now my date fields have the format mm
space dd space yyyy. Any advise will be welcomed and appreciated.

[Eric den Doop]

Hello,

Quick and dirty: create a new date field in your table. After the import has
finished issue
REPLACE ALL newdatefield WITH CTOD(strindatefield)

--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

"James" <james.garza@pcca.com> wrote in message
news:3b39eb17$2@news.devx.com...
>
> I am trying to append a converted .dat file into a free table in VFP6.
How
> do I get the date fields in the .dat file to import properly into the VFP
> table. It works through the wizard but not through an append. My .dat
file
> is delimited by character ! . Right now my date fields have the format mm
> space dd space yyyy. Any advise will be welcomed and appreciated.

[Fred - Armoni]

I disn't test but, if you SET MARK TO space(1) and SET DATE TO MDY
before the import, maybe it sould help

Fred

James a écrit :
>
> I am trying to append a converted .dat file into a free table in VFP6. How
> do I get the date fields in the .dat file to import properly into the VFP
> table. It works through the wizard but not through an append. My .dat file
> is delimited by character ! . Right now my date fields have the format mm
> space dd space yyyy. Any advise will be welcomed and appreciated.

--
FE AVP&Cie
Juillenay, Europe