Hi,
Do you have latest VFP ODBC driver installed?
The following is the connstr, you may have a try:
lcSQL = "SELECT * FROM mytable"
lcConnStr = "DSN=FoxPro Files - Word;UID=;PWD=;SourceDB=" + ;
JUSTPATH(lcTablePath)+ ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=MACHINE;Null=Yes;Deleted=Yes"
oWord.ActiveDocument.MailMerge.OpenDataSource (lcTablePath, , , , , , , , , , ,lcConnStr, lcSQL, "")HTH
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
