Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only