mail merge with SQL 2000

[Derek Ruesch]

I receive the following error message when I merge data
from a SQL Server 2000 database:

Word was unable to open the datasource.

I get this data from a view in SQL Server. If I select one
or two columns from the view, it works fine. But when I
select all of the columns, I get the error message.

I am running Word 97.

Thanks for the help!

Derek

 

[Peter Jamieson]

The problem is likely to be that the query is exceeding a 255/510 character
length limit.

When you are in MS Query, try clicking the SQL button and altering the query
so that it says SELECT * FROM myview (or you may need SELECT myview.* FROM
myview myview if you are sticking to the syntax generated by MS Query. (I'm
not sure that will work but it's probably the simlest thing to try).