To do "example 1" you have to
/include/
SQLStatement:="Select * From " & strTableName, _
and /omit/
SubType:=wdMergeSubTypeWord2000
and personally I would consider either removing the COnnection parameter
altogether or setting it to ""
Example 1 should connect using OLE DB
Example 2 should connect using DDE, which is likely the cause of your
problem.
Peter Jamieson
http://tips.pjmsn.me.uk
On 22/02/2010 09:22, InvisibleDuncan wrote:
Thanks for the suggestion, Doug, but I do already use that statement in my
revised code, as in the example I posted originally. Using that statement
allows it to run without prompting for a table, but it's one of the things
that makes it really slow. It's the speed I'm having issues with at the
moment.
Cheers,
--
Duncan
"Doug Robbins - Word MVP" wrote:
Try using the first (SQL Statement:= ) method in that knowledge base
article.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com