CopyFromRecordset Bug with Office XP

[Jeff Meeko]

I have been using the CopyFromRecordset method of the range object in
OfficeXP (through SP-2) to dump DAO (and ADO) recordsets of Access data
without incident. Immediately after installing SP-3, the copyfromrecordset
method started generating errors if memo fields contained more than 1024
characters. I can find no documentation of this bug from MS.

Has anyone else seen this or have a fix? If you have a link to report bugs,
I'd appreciate that as well.

 

[Dick Kusleika]

Jeff

I've reported it as a potential debug. I'll let you know what they say, if
anything.

 

[Jeff Meeko]

Hi Dick, any news on this yet?

Thanks.

--
Jeff

Jeff

I've reported it as a potential debug. I'll let you know what they say, if
anything.

 

[Dick Kusleika]

Jeff

Nothing yet. I've sent another message (just now) asking about the status
and I'll let you know what I hear. I haven't had the opportunity to install
SP3 yet, but I plan to do it later this week. When I do, I'll see if I can
reproduce your problem and report back here.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

Hi Dick, any news on this yet?

Thanks.

 

[Jeff Meeko]

Thanks for the follow up. I look forward to seeing what you find. I have
found the problem to be consistently reproducible on several machines
(OS=Win2000 or XP) using different custom Access applications (all using
copyfromrecordset via Excel automation).

Thanks.