General information
Category:
Coding, syntax & commands
>>>I am trying to do a Word Mail Merge with a VFP .dbf free table as my data source. I select dBase files (there is no VFP option) as my data source file type. The merge will not work if the .dbf has a date field. I am assuming that there is a compatibility problem between dBase and VFP dates. Does anyone know how I can create a dBase compatible date in VFP?
>>>
>>>Thanks
>>>
>>>Brenda
>>As far as I know, both dBase and VFP store dates in ASCII characters with DTOS format. Jan 1, 2006 is 8 character bytes "20060101"
>>
>>Are you sure it's a Date field, not DateTime or a character field representing a date?
>
>If my .dbf has a date field, then Word gives me "unable to open the data source". Otherwise it opens the .dbf data source just fine. I selected dBase III file as my data source type. That is why I am assuming it is a conversion issue.
Sorry, I don't have an answer. As a possible work-around, however, could you copy to a FOXPLUS or FOX2X table and see how that works?
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