Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Assuming there are more fields in the text file than just the date field, then I think Tore is right. To us, it looks like a date, but to SDF, it looks like a 10 wide character field. If it were the only field in the text file then you could tell it DELIMITED regardless of the fact that there are no delimiters.
Alan
>Hi Tore
>
>>I don't think you can avoid it.
>
>Well, this is the place to find out for certain. ;)
>
>Thanks!
>>
>>>Hi Tore
>>>
>>>That's the workaround I already have in place. I'm hoping to avoid that.
>>>
>>>>Hi Mike,
>>>>
>>>>1. create a cursor with the correct structure, but have a dummy character field in stead of a date field, and add a date field with the correct name at the end.
>>>>2. Import from your textfield
>>>>3. replace all datefield with ctod(yourdummyfield)
>>>>4. import from the cursor
>>>>
>>>>
>>>>>Hi Beth
>>>>>
>>>>>Yep. Tried that. Didn't work.
>>>>>
>>>>>Thanks!
>>>>>>Hi, Mike,
>>>>>> Do you have set century on?
>>>>>>>Hi all
>>>>>>>
>>>>>>>Given a text file with 11/12/1987 and a dbf with a single date field, APPEND FROM results in 11/12/19 in the date field.
>>>>>>>
>>>>>>>What must I do to have APPEND FROM import that date correctly?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement