Cetin,
I've clipped this from a reply you gave about 6 weeks ago. I use similar code, specifically "DSN=FoxPro Files;DBQ=...." Since releasing a version created on VFP6 I have several user now getting "could not find installable ISAM". Presumably this is because MS has no longer supports the Foxpro Files driver in favor of the new Visual FoxPro Tables driver. MS's solution was to use the new driver. I haven't been able to get my code to work with the new driver. How about you? Thanks for you input.

Marcus.


Here is a code portion from my mmerge class that works with w95&w97 using word.basic :

lcAlias = alias()		&& Save current alias if any
>
>lcFreeTableName = "F"+right(sys(2015),7) && Create a temp table name
>* Word doesn't like table names that are not in 8.3 format
>
>&tcSQL into table (lcFreeTableName)	&& Select recs into a temp table
>
>lcFreeTable = alias()
>lcDefDir = sys(5)+curdir()
>* Prepare DSN strings
>cDSN = "DSN=FoxPro Files;DBQ="+lcDefDir+";DefaultDir="+lcDefDir+";"
>cSourceDB = ""
>cSourceType = ""
>cOther = "DriverId=536;MaxBufferSize=512;PageTimeout=5;"
>cDataSource = dbf(lcFreeTable)
>cSQLStatement = "SELECT * FROM "+lcFreeTableName+".dbf"
>*....
>PUBLIC oWordDocument
>*....
>oWordDocument=createobject("word.basic")	&& Create word object
>WITH oWordDocument
>*...
> .MailMergeOpenDataSource(cDatasource,,, 1 ,,,,,,,;
>   cDSN+cSourceDb+cSourceType+cOther, cSQLStatement)
> && Open data source - Link to source, fastest AFAIK

cetin