Method 'CopyFromRecordset' error

  • Thread starter Thread starter Vsn
  • Start date Start date
V

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
 
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
 
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
 
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/


Vsn said:
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

Vsn said:
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
Click to expand...
Click to expand...
 
Back
Top