Method 'CopyFromRecordset' error

[Vsn]

Hi,

Is there a maximum number of records with which i can use
'.CopyFromRecordset rsCurr'?

With large number of records i have the error message '-2147467259: Method
'CopyFromRecordset' of object 'Range' failed in WriteToWorkbook', while with
lesser record the same routine works fine.

Any help is much appriciated.

Cheers,
Ludovic

 

[Ken Snell]

You're limited by the maximum number of rows in your version of EXCEL.

 

[Vsn]

The number of records I try to transfere is just 354, Excel should be able
to cope with that I do suppose? It there otherwise an other methode to
achieve the same?

Ludovic

 

[Vsn]

I found it!

Excel does not accept fields longer as 255 characters and there was a memo
field selected in the SQL string, thus 'SELECT FAQ.fID, FAQ.fPriority,
FAQ.fSubject, Left([fText],254) AS T FROM FAQ;' did the trick.

Thx for the help.
Ludovic

 

[Ken Snell]

TransferSpreadsheet will export memo fields to EXCEL without problems. See
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm for various examples.

--

Ken Snell
http://www.accessmvp.com/KDSnell/

I found it!

Excel does not accept fields longer as 255 characters and there was a memo
field selected in the SQL string, thus 'SELECT FAQ.fID, FAQ.fPriority,
FAQ.fSubject, Left([fText],254) AS T FROM FAQ;' did the trick.

Thx for the help.
Ludovic

The number of records I try to transfere is just 354, Excel should be
able to cope with that I do suppose? It there otherwise an other methode
to achieve the same?

Ludovic