>Thanks Cetin for the wise words. I will keep them in mind. I especially wasn't aware that Word tried to open datasource tables exclusively. In the meantime, FWIW, it turned out that the full command to make it work is:
>
>loWord.ActiveDocument.Mailmerge.OpenDataSource( ("c:\data\mydbf.dbf" , , , , , , , , , , , "DSN=FoxPro Files;DBQ=c:\data;", "SELECT * FROM mydbf.dbf")
>
>It apparently needed the DSN that you mentioned.
>
What I do is to get a copy to a free temp table if I use DSN. Just be sure table doesn't contain memo fields. A workaround might be to copy as an XLS and set it as Datasource.
Cetin
