Content of cells too large to hold in recordset???

[IndigoDragon]

Hi everyone,

I had a problem importing data into Excel using an ADO recordset. It imported everything upto the third column. At first I thought that any special characters in the third column were to blame. It turns out that the content of the cells in the third column is simply too long to be passed into the recordset.

Anyone know how to pass longer data into the recordset? I don't remember ever having this problem when using ASP/Access. Is it in the difference between ADO and DAO?

Thanx.