Missing ADO data

[yankee428]

I'm using Excel XP with ADO 2.8 library connecting to SQL Server 2008.

sSQL = "select * from mydb.dbo.try3"
cnn = make_connection
rst.Open cnn.Execute(sSQL)

With Range("rngBigOne")
.Clear
.CopyFromRecordset rst
.HorizontalAlignment = xlLeft
End With

This works fine if the table try3 has a field with data type of nvarchar(50), but when I change to nvarchar(MAX) nothing is return. Does anyone know how I can retrieve data via ADO using nvarchar(MAX)?

 

[yankee428]

can just edit varchar(50) to be varchar(255) in sql studio. topic closed