T
Tim
Hi Folks, I am trying to populate a worksheet from an access front end (SQL
server backend) with the following code. Some data is long text (1031 chars
and more) and it throws an error:
Has anyone succeeded with this sort of thing?
Thanks
Tim
"Application defined or Object defined error"
Do Until rs.EOF
For lCol = 0 To rs.Fields.Count - 1
oXL.Cells(lRow + 1, lCol + 1) = rs(lCol)
Next
lRow = lRow + 1
rs.MoveNext
Loop
server backend) with the following code. Some data is long text (1031 chars
and more) and it throws an error:
Has anyone succeeded with this sort of thing?
Thanks
Tim
"Application defined or Object defined error"
Do Until rs.EOF
For lCol = 0 To rs.Fields.Count - 1
oXL.Cells(lRow + 1, lCol + 1) = rs(lCol)
Next
lRow = lRow + 1
rs.MoveNext
Loop