>I'm trying to import .dat files into VFP6.0. I use the Append from command after i set date to mdy. The problem is that my date fields, which are
>in "06/26/01" 8-character format, don't seem to be getting converted
>correctly when I use this command. However, when I use the "import wizard",
>they get imported correctly, using the same input data.
>
>When I use the append from in my program, the field gets ignored and my remaining fields get shifted one field to the left, so the remaining part of my table is all garbage.
>
>Is there somewhere I can see the actual code generated by the import wizard, so see if is different than the code i'm using in my regular program?
>
>I'd appreciate any help you can give me.
>
>Thanks!!
>
>Doug Bell
>doug.bell@pcca.com


I don't know the format of your .Dat file. But you could always create a receiving empty table structure (DBF) that mimics the formkat of the incoming .Dat file and use Char(8) for your date field. Then they would be inmported as chars but it is an easy process to change them to a date later (but beware of Y2K issues).