Hi Brenda,

What version of Word are you using? I have word98 and it gived me the option of MS Foxpro tables. And then it connects fine with ODBC. Do you have vfp ODBC or oledb installed on your computer?

HTH
Beth

>>>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.