Copy Lotus Data Into Excel
 

I'm trying to get data from a Lotus database and put it in Excel. I
run into an application error when the data is too long (ex - 1800
characters). The code is

..Cells(n, 1) = xArray(1, n)

where xArray is a variant. I have to use variant or I get a 'Type
Mismatch' error.

Other things I've tried that gave me a type mismatch a
(1) Putting the data into a file with print# and write#.
(2) Putting data in Word with selection.typetext.
(3) Converting the data with
Write #1, CStr(xArray(1, n)).
(4) Converting the data using two arrays, one as a variant, and the
other as a string
txtArray(n) = varArray(n)

I'm at a loss. I don't know anything about database programming, sql,
etc. or I'd try that. If anyone has a solution, I sure could use the
help.

Thanks - JD